Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    144

    Unanswered: TransferSpreadsheet

    Hi. I have the following scripts to import an excel file into two Access tables.

    DoCmd.TransferSpreadsheet acImport, , "Header","C:\report.xls", True
    DoCmd.TransferSpreadsheet acImport, , "import","C:\report.xls", True

    The two tables are identical. For whatever reason, the excel file does not get imported to the Header table. I don't know where else to look. Can it be caused by the fact that there are two versions (2002 and 2003) of Access running the database? Can someone give me some pointers?

    Thanks

    SHK.

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    If you try to manually import to the header table using File:Get External Data:Import Does it work then? If not, it should at least tell you why it doesn't want to import it.
    Last edited by RedNeckGeek; 03-09-05 at 11:58.
    Inspiration Through Fermentation

  3. #3
    Join Date
    May 2003
    Posts
    144
    That's a really good point. Will let you know what I find out. Thanks!

Posting Permissions

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