Hi Freinds!
Please help!!!!!!!!!
I need to develop an vb application to import excel files to sql server 2000
What is the best approch to do so ?
Thanks in advance for any tips, referrence of sites or source for more info.
With regards
kashem
Printable View
Hi Freinds!
Please help!!!!!!!!!
I need to develop an vb application to import excel files to sql server 2000
What is the best approch to do so ?
Thanks in advance for any tips, referrence of sites or source for more info.
With regards
kashem
Use two recordsets and two connections: One to XLS, one to SQL Server, and perform inserts.
here's a helpful link:
http://search.support.microsoft.com/...maxResults=100