flat file to SQL

Just one additional idea to add to David's two suggestions...similar to DTS,
if it's just a straight conversion (i.e. treating an Excel sheet as a table)
you can just create a linked server using the Jet 4.0 data provider to the
Excel spreadsheet and query the data just like any other table...might make
the import easier than going through DTS, if you don't need to do a bunch
of conversion processes on the data...this also bypasses using Access as
a middle layer.

Chris

"David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote:
>you can import it into Access and then export the table to SQL Server
>you can use SQL Server Data Tranformation Services to migrate the data to
>SQL Server
>or
>you build INSERT statements w/in Excel using the CONCATENATE() to reference
>the cells
>--
>HTH,
>David Satz
>Principal Web Engineer
>Hyperion Solutions
>
>"quang" <quang@nicedream.net> wrote in message news:3d9dc4e7$1@10.1.10.29...
>>
>> hello all:
>>
>> wondering how i can get an excel file holding 1000's of products into
SQL.
>>
>> I was thinking of importing it into Access, then upsizing access and then
>> uploading it to replace the old database. I don't know if this is
>possible.
>> And I don't know how this will mess up the current site right now by
>simply
>> replacing the database. (it's an e-commerce site running Storefront -
>www.storefront.net).
>>
>> Any help or guidance appreciated. thanks.
>
>