Results 1 to 7 of 7

Thread: Data Import from Excel to SQL Server 2000

  1. Nov 17th, 2009, 12:37 AM #1
    asif_14443
    asif_14443 is offline

    Thread Starter
    Junior Member
    Join Date
    Apr 2006
    Posts
    19

    Data Import from Excel to SQL Server 2000

    I want to import 3 columns with data from Excel to SQL Server 2000
    Any body can help or can give me VB 6 programme. Thanks.
    Reply With Quote Reply With Quote
  2. Nov 17th, 2009, 02:33 AM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Data Import from Excel to SQL Server 2000

    Have a look at this tutorial from si_the_geek.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Nov 17th, 2009, 09:05 AM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Data Import from Excel to SQL Server 2000

    That could actually be the long-winded approach in this case... I recommend taking a look at the articles that are specifically about Excel/SQL Server in our Office Development FAQs (at the top of the Office Development forum)
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  4. Nov 19th, 2009, 09:43 AM #4
    Big Red
    Big Red is offline
    Member
    Join Date
    Oct 2007
    Posts
    56

    Re: Data Import from Excel to SQL Server 2000

    Are you talking about this question? How do I transfer data from SQL Server to Excel using ADO? If not, which one are you talking about?
    Reply With Quote Reply With Quote
  6. Nov 19th, 2009, 10:00 AM #5
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Data Import from Excel to SQL Server 2000

    That is one of the them - there is another one about SQL Server there too.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  7. Nov 23rd, 2009, 07:21 AM #6
    asif_14443
    asif_14443 is offline

    Thread Starter
    Junior Member
    Join Date
    Apr 2006
    Posts
    19

    Re: Data Import from Excel to SQL Server 2000

    yes Mr Big Red . I want a little VB 6.0 programm that could Import data from MS Excel file and then Paste in MS SQL Server 2000 database.
    Reply With Quote Reply With Quote
  8. Nov 23rd, 2009, 07:24 AM #7
    asif_14443
    asif_14443 is offline

    Thread Starter
    Junior Member
    Join Date
    Apr 2006
    Posts
    19

    Re: Data Import from Excel to SQL Server 2000

    Mr. Dee-U(Post No.2) I have followed the link and read the entire article, it i very difficult kind of programme. Can u please tell me some easy way?
    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