Hi BP,
Budget Programmer wrote:
Hello,
Is there some function/utility/etc. that will read a row of Excel
data, and create a file with SQL statements to load the data into
SQL? We want to avoid using ADO and the traditional "insert" method.
If you're talking about importing the data into SQL Server, you can use DTS
or BCP to import the data directly from Excel into SQL Server.
If it's a limited # of rows of data, I typically dynamically generate the
INSERT statements using Excel, then copy/paste the resulting script into the
SQL SMS and execute it from there.
--
Regards,
Jake Marx
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]