Excel Spreadsheet -> SQL Server
Posted on 2007-03-19
I have an excel spreadsheet that I need to insert into two database tables.
Each row in the spreadsheet signals a new record, but there is a catch. Columns A to J need to go into one table, while columns K to O need to go into another table but there needs to be a link/key created between the two tables so there's a link.
Any ideas anyone?