DAO text database
 

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.

DAO text database
 

wrote in message ...

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/de...htextfiles.asp

--