General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Inserting into tables from xls spreadsheet
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.
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