Transfer spreadsheet to SQL server cant append
Posted on 2006-07-18
Hi all - Im using vba to programmatically transfer a spreadsheet to sql server, from vba code in my adp file.
i.e. docmd.transferspreadsheet acImport, acSpreadsheetTypeExcel10, tableMyTable, pathToFile,true
Because it doesnt correctly determine the data types, I figured I'd create the table first, then use this to append the data, as the help file explicity tells me that Data will be appended if the table exists or a table will be created if not.
However I get an error "Run Time error 3146, ODBC call failed, There is an already an object named 'mytablename' in the database(#(2714)"
Is there a way I can use transferspreadsheet to append to my table?