importing excel to sql

[versillus]

I'm using ms sql 2000. I want to import excel file to table in sql.
I want to use it in store procedure. Anyone can help me.

 

[petertickler]

Use the Data Transformation Services to import your spreadsheet into your SQL database.

It is pretty straightforward to use.

 

[versillus]

but if i want combine with program in visual foxpro, how can i do that

 

[petertickler]

I would suggest you first try it with DTS, then save the DTS. This will give you some SQL which you can then copy into your Visual FoxPro application, and then execute from there. I very rarely use Visual FoxPro, but that is how I would approach the problem with Delphi.