Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 import to excel 2000

Status
Not open for further replies.
rwttm001

rwttm001

IS-IT--Management
Nov 20, 2002
26
GB
Using the code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "tblTrade", "C:\internal.xls", True

I wish to export all data from tblTrade in Access 97 to Excel 2000, but I am geting the following error:

Table 'tblTrade' already exists. (Error 3010)

Any help would be greatly appreciated!

Cheers
MWR
 
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
399
Viswa.R
Viswa.R
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
2K
lameid
lameid
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
535
Andrzejek
Andrzejek
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
823
Knicks
Knicks

Part and Inventory Search

Sponsor

Back
Top