Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Import Excel File into Access where Source Fields not Constant

Status
Not open for further replies.
greenbird

greenbird

Technical User
Jul 24, 2003
10
CA
How do you import an Excel file into an Access table, using code, and where the Excel fields are not constant regarding the total number of fields, and Excel field names may also be changing, from file to file?
 
Sort by date Sort by votes
You may consider the DoCmd.TransferSpreadsheet method importing the sheet in a brand new temporary table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
320
Viswa.R
Viswa.R
DarkOne72
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
998
lameid
lameid
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
452
Andrzejek
Andrzejek
BFroeschlKC
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
1K
dhookom
dhookom
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
418
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top