Results 1 to 1 of 1

Thread: Excel File Read

  1. #1
    Join Date
    Feb 2004
    Location
    Irving, TX (Dallas, Fort Worth)
    Posts
    379

    Unanswered: Excel File Read

    All,

    I had an example of how to do this and somehow lost or misplaced it.

    Need to run a routine on 98 invoice files to read into DB and do AR aging on them.

    Did the:
    Code:
    dir *.xls /b > inv_xls.txt
    to capture the names and now need to read cell by cell into pre-existing invoice DB. Tables are tblInvoice and tblInvoiceDetail. I uploaded the documenter output on structure.

    Invoices are modified from the default MS Office Invoice templates by Village Software.

    I tried using the Transferspreadsheet command, but the macros in th SSs kept them from opening.

    The example I had, previously, centered around the command ActiveWorkSheet, which is about as much as I can remember.

    DBS4M
    Attached Files Attached Files

Posting Permissions

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