Results 1 to 2 of 2

Thread: Excel

  1. #1
    Join Date
    Dec 1969

    Default Excel

    How can VBScript interface with an Excel Spreadsheet, I need to take the info from an speadsheet and transfer it to an SQL Database....<BR><BR>Do you need a third party component to do this, or can the Excel Speadsheet act as a Database that can be interfaces via a Recordset?

  2. #2
    Join Date
    Dec 1969

    Default RE: Excel

    You can insert an Excel Spreadsheet into a SQL Server Db using DTS or Bulkcopy!<BR><BR>Excel can be opened like a DB with a recordset

Posting Permissions

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