SQL From syntax

[joethall]

Can anyone send me the full specs for the From option in MS Access SQL?



I have this example:
SELECT * INTO NewTable FROM [Text;HDR=Yes;FMT=Delimited;Database=C:\Temp].[Temp.txt]

I see parameters such as Text, HDR, FMT, & Database and I need to specify a semi-colon as the separator.

A full description of the options would be much appreciated.

I have a flat file of the format where this is the first line and it contains the column names.
Mon;ID ;Clin;LastName ;FirstName ;M;Suf;City ;St;ZIP

I need to write VBscript code that creates the appropriate SQL and then runs it.
My current guess is above.

Thanks

Joe

[Gicu]

Maybe this helps you:https://www.codeproject.com/Articles...b-fixed-length

But why not just import or link the file using Docmd.TransferText and then use Access to process it?

Cheers,