Importing CSV Files into Access

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
 
G

Guest

I've never done this before so can I ask if this is something that can be
done in Access using VBA code?
 
J

John Nurick

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

csv Import into Access db 2
Using the Text Qualifier in the Import Wizard 10
Access Importing csv daily files into access 2007 1
Importing Text Files Into Access 1
Import files into access 1
Access is dropping rows on import 1
import csv files to access db 2
Data type issue when importing from excel to access 1

Top