Excel import routine

Results 1 to 2 of 2

Thread: Excel import routine

  1. #1
    Join Date
    Dec 1969

    Default Excel import routine

    I have a routine whereby the user will be able to upload and import an excel or csv file into my program. <BR><BR>I have the csv version working fine and the data is being put into an array and this is being done via the CreateObject("Scripting.FileSystemObject") method<BR><BR>However, the excel version is a different proposition as I have the encrypted header and footer to contend with. <BR><BR>Can I have your opinion please. Should I connect to the excel spreadsheet as if it were a database or is there a better method to read an excel spreadsheet via the CreateObject("Scripting.FileSystemObject") method.

  2. #2
    Join Date
    Dec 1969

    Default The FileSystemObject is only..

    .. really good at dealing with ASCII files.<BR><BR>Connect to the Excel sheet w/ ADO as-if it were a database.

Posting Permissions

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