How to assure a "TransferSpreadsheet" import goes to desired Table

  • Thread starter EagleOne@microsoftdiscussiongroups
  • Start date
E

EagleOne@microsoftdiscussiongroups

2003

VBA Macro in Database Tools.mdb creates Reconcile.mdb then
imports two tables: 1) a "Text" import; 2) an Excel file import

For the text import, I use: ( and it works fine with a Schema.ini file)
dbs.Execute "SELECT * INTO STARSData FROM _
[Text;FMT=Fixed;HDR=No;DATABASE=" & myPath _
& ";].[STARSData#txt];", dbFailOnError

For the Excel import, I use (it works but places the data in the wrong table):
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, _
strTableName, "C:\Reconciliations\myData.xls", True

What VBA code can I use to force the data into dbs (Reconcile.mdb) and not
into Tools.mdb where it is now going?

TIA EagleOne
 

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

TransferSpreadsheet (via VBA) getting : "Read Only" error message 0
Help with Access VBA to create a new file and import textfile data 6
VBA help From db1.dbf have module to create then import Text 0
How to re-order columns Programatically. Possible? 6
how to paste a copied Excel range into a table in Access via VBA?transferspreadsheet inadequate 2
Importing EXCEL Spreadsheet into ACCESS using TransferSpreadsheet method 4
How to limit a copy to one record; not the entire table 9
How to import a file including header into a new document in Word 1

Top