CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. October 16th, 2004, 12:07 AM #1
    phuongnam3000
    phuongnam3000 is offline Member
    Join Date
    Aug 2004
    Location
    VietNam,HCM
    Posts
    28

    Import .xls to Database (SQL)

    Hi! Everyone,

    I want to write a app import .xls to SQL Server
    How can I import .xls to SQL Server ?

    Anyone have some demo.
    Please help me.

    Thank you so much.
    Best regards,
    Reply With Quote Reply With Quote
  2. October 16th, 2004, 04:57 AM #2
    MichaelNattfalk
    MichaelNattfalk is offline Junior Member
    Join Date
    Sep 2004
    Location
    Sandhem, Sweden
    Posts
    20

    Re: Import .xls to Database (SQL)

    Hi.

    The easiest way probably would be to create a macro with VBA in the Excel file that creates a connection to the SQL server and then adds the information.

    Don't think it would be to hard to do.

    If you want me to help, feel free to contact me on MSN or ICQ.

    Regards,
    Michael
    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

Featured