Import eksport excel files

G

Guest

Hi
I have this
Private Sub eksporter_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"tblSportsgren", "C:\valutakurser.xls"
End Sub
this working
Then i try this
Private Sub importer_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"C:\valutakurser.xls", "tblvalutakurser"
End Sub
But then i get a error

resgards
Alvin
 

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

expected format 3
Export to Excel when password protected 3
Transfer Spreadsheet Code 4
Excel Automation from Access 5
Export Query to Excel in VB 1
FileDialog vs. API and Multi-Select 3
export file to excel in microsoft access 1
Opening Excel Workbook from Access after TransferSpreadsheet 2

Top