Imports excel data to an sql table Logan 30.09.2006 17:22:01 I need to create a table with data from an excel book, I am new on this, if someone can help me I'll appreciate it a lot. Thanks in advance.

Re: Imports excel data to an sql table "Dave Patrick" <DSPatrick[ at ]nospam.gmail.com> 30.09.2006 17:46:32 Easiest to use the import wizard from SQL Server Enterprise Manager (DTS) -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Logan" wrote: |I need to create a table with data from an excel book, I am new on this, if | someone can help me I'll appreciate it a lot. Thanks in advance.

Re: Imports excel data to an sql table Logan 30.09.2006 19:08:01 But i need to do it in runtime with code, i need to select an excel file and with it create the table. "Dave Patrick" wrote: [Quoted Text] > Easiest to use the import wizard from SQL Server Enterprise Manager (DTS) > > -- > > Regards, > > Dave Patrick ....Please no email replies - reply in newsgroup. > Microsoft Certified Professional > Microsoft MVP [Windows] > http://www.microsoft.com/protect > > "Logan" wrote: > |I need to create a table with data from an excel book, I am new on this, if > | someone can help me I'll appreciate it a lot. Thanks in advance. > > >

Re: Imports excel data to an sql table "Dave Patrick" <DSPatrick[ at ]nospam.gmail.com> 30.09.2006 20:42:04 You can probably do this with a DTS package. You might look around here. http://www.sqldts.com/ or if nothing else look at ADOX http://www.4guysfromrolla.com/webtech/013101-1.shtml http://support.microsoft.com/kb/303814/ -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Logan" wrote: | But i need to do it in runtime with code, i need to select an excel file and | with it create the table.