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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disregard FieldNames

Status
Not open for further replies.
LiLgUrL

LiLgUrL

Technical User
Feb 9, 2003
59
CA
Greetings! Is it possible to import an excel file without considering the fieldnames? Like from the excel file the fied name is LastName and in my table it is Lname... when i import i receive an error.
 
Sort by date Sort by votes
Why not importing the excel file in a temporary table and then do an append query ?

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

davedave24
  • Locked
  • Question
Using .xlUp but disregarding formulas in cells
Replies
3
Views
119
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top