J
Joe Delphi
Hi,
I am using the TransferSpreadsheet command to transfer Excel
information into an existing database table. The problem is that instead of
going into the existing database table, it creates a new table with the same
name and puts the data there. The command I am using is this:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tlkpPayScheduleNSR", Filepath & "\Consumer Pay Schedules.xls", True,
ConNSRBounds
The Access application is an .adp file which connects to Microsoft SQL
Server on the back end - so not sure if you have to do anything special
because of that situation. The existing table is owned by user1 as it
should be, but the newly created table is owned by dbo.
How do I append data to the existing table rather than create a new
table?
Any help appreciated.
JD
I am using the TransferSpreadsheet command to transfer Excel
information into an existing database table. The problem is that instead of
going into the existing database table, it creates a new table with the same
name and puts the data there. The command I am using is this:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tlkpPayScheduleNSR", Filepath & "\Consumer Pay Schedules.xls", True,
ConNSRBounds
The Access application is an .adp file which connects to Microsoft SQL
Server on the back end - so not sure if you have to do anything special
because of that situation. The existing table is owned by user1 as it
should be, but the newly created table is owned by dbo.
How do I append data to the existing table rather than create a new
table?
Any help appreciated.
JD