I need some code to import a text file from the Desktop and create a table called Invent. How? Thanx
F fhs Registered User. Local time Today, 05:13 Joined Aug 8, 2001 Messages 68 Feb 17, 2005 #1 I need some code to import a text file from the Desktop and create a table called Invent. How? Thanx
H hollering Registered User. Local time Today, 00:13 Joined Feb 15, 2005 Messages 38 Feb 17, 2005 #2 Have you considered using ODBC and then linking your database to the text file?
L Liv Manto Registered User. Local time Today, 05:13 Joined Apr 26, 2001 Messages 266 Feb 17, 2005 #3 DoCmd.TransferText acExportDelim, "Standard Output", _ "External Report", "C:\Txtfiles\April.doc" search for Transfer text method
DoCmd.TransferText acExportDelim, "Standard Output", _ "External Report", "C:\Txtfiles\April.doc" search for Transfer text method
F fhs Registered User. Local time Today, 05:13 Joined Aug 8, 2001 Messages 68 Feb 17, 2005 #4 ODBC will not be needed. The txt file is on the C: drive through another operation. Thanx...