View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.