Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    reading/writing data to excel (Access 2007)

    reading/writing data (Access 2007)
    <post:=724,220>post 724,220</post:>





    I'm trying to use a form in an Access database to read data from another access database and write it into an Excel spreadsheet. I'm using this code:

    strSQL = "SELECT * INTO [Excel 8.0;Database=" & strExcelFile & "].[Failure_Data] FROM " & "" & strTable & ""

    but I'm getting an error message saying: "External table is not in the expected format".

    Is the "8.0" right? Does anyone know what i need to do?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: reading/writing data to excel (Access 2007)

    Please post all replies in the Access thread. This one is locked to prevent duplication.

Posting Permissions

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