Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to import a text file
- Thread starter patyavila
- Start date
One method is to use the following approach.
filename = "c:\ImportScores.csv"
DoCmd.TransferText acImportDelim, , "tblImportScores", filename
You may want to investigate if a spec file is required.
Another approach is to open the file and read and parse one line at a time. Obviously less efficient than the Transfer Text method.
htwh,
Steve Medvid
"IT Consultant & Web Master"
Chester County, PA Residents
Please Show Your Support...
filename = "c:\ImportScores.csv"
DoCmd.TransferText acImportDelim, , "tblImportScores", filename
You may want to investigate if a spec file is required.
Another approach is to open the file and read and parse one line at a time. Obviously less efficient than the Transfer Text method.
htwh,
Steve Medvid
"IT Consultant & Web Master"
Chester County, PA Residents
Please Show Your Support...
- Status
Similar threads
- Locked
- Question