Please Help!!!

[Boris613]

I HAVE A CODE which takes an excel spreadsheet finding a tab and exporting data into the table:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Test Import Specification", "\root\lib\Controllers\FID\Corporate Trading\2006\1206\Completed Dailies\PI1208", True, "Heffalump!"

What I want is to create a different table with a specific fields and transffer data from "Test Import Specification" in to a new table!!!!

Please help,
B

 

[Keith Nichols]

Only post once

Boris,

Only post your queries once and try to post them in the most appropriate part of the forum. You can go to threads you start and use the thread tools to delete the unwanted entries.

I think your problem can be solved by creating a query in design view. Show the table that has the data in you want to transfer.

Select the fileds you want to transfer to the new table (double click or drag them into the design grid).

Run the query and confirm that the data is what you want. Go back to desig view and change the query to a maketable query. Alternatively, if the table you want to transfer the data to already exists, change it to an append query.

Post back if you need further guidance.