Results 1 to 2 of 2

Thread: importing Execl files to SQL Server

  1. Jan 5th, 2004, 09:14 AM #1
    makbd
    makbd is offline

    Thread Starter
    Member
    Join Date
    Nov 2002
    Location
    Bangladesh
    Posts
    48

    importing Execl files to SQL Server

    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
    Reply With Quote Reply With Quote
  2. Jan 5th, 2004, 10:21 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width