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

import excel sheet into table

Status
Not open for further replies.
Pampers

Pampers

Technical User
Apr 7, 2004
1,300
AN
Hi everyone,
In Access (2007) you have the option to import an excel sheet into a new table manually (with a wizard). How can you automate this process? I can not append the sheet to an existing table since the sheet various in format (more or less columns with different column headers)

Pampers [afro]
Keeping it simple can be complicated
 
Sort by date Sort by votes
Mmm, it always funny after one posts a problem, one gets more inventive and figure it out. Just give up table name that doesn't exist yet, and access creates it...

Pampers [afro]
Keeping it simple can be complicated
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Sending data to Excel 1
Replies
2
Views
188
TrekBiker
TrekBiker
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
200
Andrzejek
Andrzejek
iamchemist
  • Locked
  • Question
Getting Into Break Mode?
Replies
7
Views
481
iamchemist
iamchemist
MattGreer
  • Locked
  • Question
Enter Me.Date into a query triggered in a Form button 1
Replies
6
Views
182
MattGreer
MattGreer
bosk0
  • Locked
  • Question
Getting a syntax error in INSERT INTO statement 1
Replies
5
Views
198
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top