Solved

Need to find Specification for an excel file import.

Posted on 2013-01-31
2
349 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

688 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