Need help importing data to SQL

#1

I know DTS will do the job.

Also look into setting-up a linked-server to this Excel
file. Gives you much better control over the Excel fields,
Excel gets picky sometimes. This is my preferred choice.

Hope this helps.

Sunil.

Quote:

-----Original Message-----
Hi,

I have an Excel Spreadsheet with data that I need to get
into a SQL
Database. What is the best way to do that?

Thanks,

Dan

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Need help importing data to SQL

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Need help importing data to SQL - 09-17-2003 , 11:19 AM