Importing CSV Files into Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I'm needing to do, through programming (VBA) to import a CSV file and
have all the fields import in as Text regardless of it being a number or not.
I can't use a import specification, because the program will be running and
importing all different files, with different number of columns and different
data. So it all has to be through programming. I have the typical
docmd.transfertext command. But I'm not sure if there's away to make all
fields be imported as text.

Thanks,
Nancy
 
I've never done this before so can I ask if this is something that can be
done in Access using VBA code?
 
See my answer to your question in the thread "Using the Text Qualifier
in the Import Wizard"
 

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

Access Importing csv daily files into access 2007 1
Using the Text Qualifier in the Import Wizard 10
Import files into access 1
csv Import into Access db 2
Importing Text Files Into Access 1
Problem with access acImportDelim importing csv with headers 1
Access Project SQL Import csv 4
import csv files to access db 2

Back
Top