Importing a pipe delimited text file into Access using VB 1

[jjk238]

I am trying to import a pipe delimited text file into MS Access. The code that I am messing with is:


strPath = "C:\cooper.txt"
strTable = "PIPE"
DoCmd.RunSQL "DROP TABLE " & strTable
DoCmd.TransferText acImportDelim, , strTable, strPath


I'm not sure what to put for the first parameter of acImportDelim, which asks for [SpecificationName]. I also don't know if I need to put something in for [HasFieldNames],[HTML TableName], or [CodePage].

The code may or may not be along the proper lines for this.....I'm not sure. Thanks for your help!

 

[SeeThru]

To create a specification, first import the table manually. On the last page of the import wizard, use the save button to save a specification (you give it a name - note what this is). The specification is savid with the database.

Then, use this specification name in your code. It will use all the options you had selectd in the wizard, including field name use, data format, and fields to ignore.



SeeThru
Synergy Connections Ltd - Telemarketing Services

 

[SoCalAccessPro]

I have a class module that imports delimited text, if you need it.

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[jjk238]

Thank you!! It works perfect now.