Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Need to find Specification for an excel file import.

Posted on 2013-01-31
2
Medium Priority
?
382 Views
Last Modified: 2013-01-31
I need to define the fields for:        

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Totals", Me.txtTotalsPath, True

This solution in this below link worked for me when I needed to change the specification on a .txt file

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27994625.html

BUT now I have a .xls file that I need to change specification and I can't find an "advanced" button...  HELP!
0
Comment
Question by:gcgcit
  • 2
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 38840559
there is no import specification needed to import a .xls, .xlsx files

what you  need to do, is to import the excel file into a temp Table

then do what you need to do, using the temp Table
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38840564
or open the .xls file and change the column names using vba codes
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question