General information
Category:
Coding, syntax & commands
Henry, I didn't realize that it's a version 1.x mdb. I suspect that even using ADO, you might run into the same issues because of a newer version of Microsoft Data Objects on the system. I can't test it for you, but I'm guessing the Convert dialog might still pop up.
Alan
>Hi Alan:
>
>>I'm not entirely sure what you mean by transferring manually and you want to point to a dialog box and transfer the file to excel.
>
>Meaning that I use the "Get External Data" from within Excel to connect to the Access database, then select a file and save that data in the worksheet.
>
>The only simple way I know is to open Access, open a database, choose a table, and do a 'Save As' to Excel.
>>
>I have some trouble here. When I open Access, and then try to open a mdb file, the Convert Database dialog box appears. Clicking OK displays a message "This operation is not supported for Microsoft Access 1.x databases."
>
>And, thank you for that orientation in ADO. It is very much appreciated.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only