>Hey everyone,
>I am trying to insert into 3 tables data from one spread sheet. The problem is that not all the columns in the spread sheet go into all 3 tables. Can I run SQL like on Microsoft Sequel Server and code something like:
>insert into table
>select (col1, col2,col5,col9......)
>From *.xls
Yes, you can. See Q278973 how to make it using ADO. There is also ISAM_xls sample in file #
10002. I think it possible also with ODBC connection.