updating a DB from delimited text files **resolved**

[TeaSpoon]

hi...

im new to vb and im faced with the problem of updating a DB from some pipe delimeted text files.

luckily ive got someone's code to follow

it goes like this

accApp.DoCmd.TransferText acImportDelim, "mainmb Import
Specification", "mainmb", gstrFileName, True

i would like to know where in that line do i specify the character of delimitation ?
can anyone help me
thanx


Solution ->

you need to save a thing called a Import/Export Specification for this line to work, this Import/Export Specification sits mysteriously in the database file (access) and you can save it using the export wizard in access, when exporting to a text file. I had to save one Import/Export Specification for each table that i needed to upate.
This Import/Export Specification specifies how the text file is set up ie its delimiter character and whether a text field is encased in double quotes.

hope that helps