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"
 
Back
Top