Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Export data to access from files in excel
0 views
Skip to first unread message
DreamKid
Dec 14, 2009, 5:57:01 PM12/14/09
to
I have many excel files that each holds one customer purchases identified by
an ID number. I need to creat a database that contains all sold item ID
numbers from all customers. Is there anyway to export this information from
all files to one database in access? all files are in one folder. I have
about 25 excel files.
Thank you
an ID number. I need to creat a database that contains all sold item ID
numbers from all customers. Is there anyway to export this information from
all files to one database in access? all files are in one folder. I have
about 25 excel files.
Thank you
PieterLinden via AccessMonster.com
Dec 14, 2009, 10:03:37 PM12/14/09
to
You can use DIR() to loop through all the Excel files in a folder. Then you
can use TransferSpreadsheet to import the data into your database.
Check out Ken Snell's website:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
if you look up DIR in the VBA help, you should find an example... post back
if you need more help.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200912/1
0 new messages