Excel Sheet SQL Table

Question

I have an Excel sheet. The top row corresponds to column names while successive rows each represent an entry.

How can I convert this Excel sheet into a SQL Table?

I am using SQL Server 2005.

you could use a vb script to create the necessary sql insert statement. shouldn't be too stressful. — TZHX
– TZHX, Commented Nov 30, 2010 at 12:31

bernd_k · Accepted Answer · 2010-11-30 12:35:44Z

3

That depends on which program you use for SQL . If you have SQL-Server installed. SSIS Import and Export Wizard SSIS Import and Export Wizard would be a good choice.

answered Nov 30, 2010 at 12:35

bernd_k

12.1k7 gold badges50 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

smirkingman · Accepted Answer · 2010-11-30 13:58:33Z

1

Use MS Access

Create a new MDB

Import the Excel file as a new table

Use the SQL Server upsizing wizard to transfer the table to SQL Server

answered Nov 30, 2010 at 13:58

smirkingman

6,4365 gold badges37 silver badges48 bronze badges

Collectives™ on Stack Overflow

Excel Sheet SQL Table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related