Export and import from Excel- where did the data go

P

P Nahser

I am a beginner- please help.
I have an export command (see below) that saves "gxt cardiolite table" in
"my documents as an excel file.
DoCmd.OutputTo acTable, "GXT Cardiolite table",
"MicrosoftExcelBiff8(*.xls)", "", False, "", 0
(I made a macro and let Access convert it to code for me)

I have a different style import command (see below) that I thought was
importing that same file back into access. It is getting a different version
of "gxt cardiolite table" that I must have exported in the past - but not the
one I can find in "my docs"

DoCmd.TransferSpreadsheet acImport, 5, "gxt cardiolite table", "gxt
cardiolite table", True, ""
Is there a better way to do this?
thanks. PN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import from and export to "my documents" 3
Export Report with Graph to Excel error 2495 1
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Export / Import 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
import error into Access 2003 with Excel 2003 0
Import Excel named range into Access 2
Export Access pivot table to Excel - VBA solution 0

Top