Import code for text file
A few days ago an expert helped me with the importing of an Excel file into an Access database via:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTempFieldNotesImport",
But now I need to do the same thing but with a tab delimited text file.
What should this line of code look like to do that?
--Steve
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTempFieldNotesImport",
But now I need to do the same thing but with a tab delimited text file.
What should this line of code look like to do that?
--Steve
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.