import from excel file

  • Thread starter Thread starter JIM.H.
  • Start date Start date
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Import CSV File Into Linked Table 2
Type Conversion Error While Importing (Time Field) 8
regularly importing from csv 1
Append Tables 5
Access Importing csv daily files into access 2007 1
Which is the best MBOX Converter Tool different formats conversion? 4
Programmatically Change Double Data Type To Long Integer 8
Csv import: direct link vs temp table dump 2

Back
Top