transferSpreadsheet???

  • Thread starter Thread starter Downie
  • Start date Start date
D

Downie

How do I transfer a table to a spreadsheet in VB for Applications?

DoCmd.TransferSpreadsheet.??????
 
I THINK I'M Getting closer. Seeing syntax though

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, excel,
"C:\PRSPREADSHEETS\jobs.xls"
 
I THINK I'M Getting closer. Seeing syntax though

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, excel,
"C:\PRSPREADSHEETS\jobs.xls"
Click to expand...

What is
excel
in yourcode?

Is that supposed to be the name of the table or query in your database
that you wish to export?
Then put it within quotes (it's supposed to be a string).

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "excel",
"C:\PRSPREADSHEETS\jobs.xls"

If that is not the name of the table, but a variable, then:

Dim excel as string
excel = "The Name of Table or Query"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, excel,
"C:\PRSPREADSHEETS\jobs.xls"

Then your code should work without quotes around excel.
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Transferspreadsheet import conflict 3
Possible to import a specific sheets data from excel into access? 1
TransferSpreadsheet Excel 2007 into Access 2003 2
Syntax for TransferSpreadsheet method 4
docmd.transferspreadsheet 2
Export to Excel - Access 2013 to Excel 2013 0

Back
Top