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

Importing multiple Excel files question????

Status
Not open for further replies.
WB786

WB786

MIS
Mar 14, 2002
610
I have seen many posts as to how to use the Transfer method and use the macro that is all pretty easy.

But what I am looking for is to click on a button that would let say import-in 9 different Excel spreadsheets into one pre-defined table. Now the table fields will not match the Excel ones so in the code I need to say somehow to import First Name field from Excel into table's CC_FirstName field instead.

Can this be done???? Please help!!!

Thanks in advacne,
-WB
 
Status
Not open for further replies.

Similar threads

JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
536
SkipVought
S
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
385
SkipVought
S
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
319
dhookom
dhookom
puforee
  • Locked
  • Question
Error when importing Excel with blank dates
Replies
4
Views
251
dhookom
dhookom
haeddy
  • Locked
  • Question
Mail Merge 2 Excel Files
Replies
1
Views
92
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top