|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
INSERT LOTS of valuesI have to INSERT Lots of Values from an Excel spreadsheet to a #temp table
and then use the valus in this #temp table to update rows in our database. How can I INSERT LOTS of rows, over 22,000, to this #temp table with the values that are in this Excel spreadsheet??? Thanks in advance for your help wnfisba wnfisba wrote:
> I have to INSERT Lots of Values from an Excel spreadsheet to a #temp table Use a T-SQL query using OPENROWSET, or use the DTS import wizard...> and then use the valus in this #temp table to update rows in our database. > > How can I INSERT LOTS of rows, over 22,000, to this #temp table with the > values that are in this Excel spreadsheet??? > > Thanks in advance for your help > > wnfisba Have you considered using DTS ( data transformation services ) with a
staging base table? You can load the data from a variety of data sources, including Excel spreadsheet to a base table and do lots of custom transformations. -- Anith you can link this spreedsheet into sql server and it will work as a
table. from there you can do t-sql wnfisba wrote: Show quote > I have to INSERT Lots of Values from an Excel spreadsheet to a #temp table > and then use the valus in this #temp table to update rows in our database. > > How can I INSERT LOTS of rows, over 22,000, to this #temp table with the > values that are in this Excel spreadsheet??? > > Thanks in advance for your help > > wnfisba  |
|||||||||||||||||||||||
Other interesting topics