General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
You could use a plain:
append from (XLSFILE) XLS for (condition_on_table)
>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
>
>Any help would be appreciated. Thanks.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only