FYI you can find the connection string for excel @ http://www.connectionstrings.com/
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Friday, October 21, 2005 9:23 AM To: [email protected] Subject: Re: [AspNetAnyQuestionIsOk] excel spreadsheet to sql datatable Use dataAdapter fill to get the Spreadsheet into a datatable. The right connection string will connect to Excel data as if it were a DB. Unmap the dataTable from Exce and Remap it to sqLserver and tell the DataTable to acceptchanges. ADO.net can create the table and transfer the data easily. this is really what ADO.net thrives at converting data. On 10/21/05, Zed Burton <[EMAIL PROTECTED]> wrote: > I need to create a sql data table from an excel spreadsheet. Any > ideas? Yahoo! Groups Links ************************************************************************* This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************* ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
