DAO text database

[Guest]

Hi

Does anyone know how to insert a TAB delimited file into
and access table?

CSV file is fine but I also have TRAB delimited files to
insert

strSql = "INSERT INTO [tblWrapperTrades] SELECT * FROM
[TEXT;DATABASE=Y:\Dev\LTRM\Dev].[CH_Wrapper.csv]"

this works fine.

 

[onedaywhen]

Does anyone know how to insert a TAB delimited file into
and access table?

CSV file is fine but I also have TRAB delimited files to
insert

strSql = "INSERT INTO [tblWrapperTrades] SELECT * FROM
[TEXT;DATABASE=Y:\Dev\LTRM\Dev].[CH_Wrapper.csv]"

this works fine.

To specify tab delimited you must use a schema.ini file:

http://msdn.microsoft.com/library/d.../en-us/office97/html/workingwithtextfiles.asp

--