Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Excel Data into Multiple Tables

Status
Not open for further replies.
19991008

19991008

MIS
Jul 22, 2005
3
US
Hi

I have a SQL Server database which has many related tables.
At the moment, all of the data for each table is held in one single excel file, one single excel sheet. Each column in the excel file represents a field, each row represents a record.

My question is this, how can i import all of the data from the excel file, into multiple tables in one attempt?

Many thanks

 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Truncated Excel Fields
Replies
0
Views
196
grnzbra
grnzbra
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
294
markjoseph1232
markjoseph1232
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
154
botatun
botatun
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
74
mutley1
mutley1
kat50
  • Locked
  • Question
How to import a txt file based on position
Replies
0
Views
190
kat50
kat50

Part and Inventory Search

Sponsor

Back
Top