Import Excel Data

Question

Post reply

Import Excel Data

Jéan Moore

SSC Rookie

Points: 43
More actions
August 1, 2007 at 9:36 am

#118021

Is there a way to link an excel file to SQL Server 7.0 like in Microsoft Access?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Amit Choudhary-216780 Old Hand Points: 384 More actions · Answer 1

Convert XLS to CSV and use bulk insert command.

OR Use DTS in enterprise manager.

Hope this will help u.

Amit Choudhary

Jéan Moore SSC Rookie Points: 43 More actions · Answer 2

Jéan Moore

SSC Rookie

Points: 43

August 1, 2007 at 10:18 am

#723945

Thanks! I think it will help...

David-250683 Hall of Fame Points: 3452 More actions · Answer 3

David-250683

Hall of Fame

Points: 3452

August 1, 2007 at 2:22 pm

#723995

What if the data contains commas?

Sarah Dutkiewicz SSCommitted Points: 1870 More actions · Answer 4

As long as the data is in distinct columns in Excel, it should be fine importing the data, even if the column data contains commas.

David-250683 Hall of Fame Points: 3452 More actions · Answer 5

How does DTS know whether the comma is regular or a delimiter?

Jeff Moden SSC Guru Points: 1004432 More actions · Answer 6

I believe it uses the TAB delimiter for Excel spreadsheets...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)