import from excel file

J

JIM.H.

Hello,
I am trying to open an excel file (csv file and name is
changing all the times) and import data into a table in
Access. I was planning to create a table link to the file
in my module and run an append query and delete the link.
However I do not know if I can create table link in the
module automatically, can I do that? Or is there any other
way to accomplish appending from a csv file?
Thanks,
Jim.
 
J

John Vinson

Hello,
I am trying to open an excel file (csv file and name is
changing all the times) and import data into a table in
Access. I was planning to create a table link to the file
in my module and run an append query and delete the link.
However I do not know if I can create table link in the
module automatically, can I do that? Or is there any other
way to accomplish appending from a csv file?
Thanks,
Jim.
Click to expand...

Take a look at the VBA online help for TransferText. (A .csv file can
be viewed from Excel, but it's not actually a spreadsheet, but rather
a text file).

John W. Vinson[MVP]
(no longer chatting for now)
 
Top