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 SkipVought 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
0
0
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
67
TrekBiker
TrekBiker
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
62
Andrzejek
Andrzejek
iamchemist
  • Locked
  • Question
Getting Into Break Mode?
Replies
7
Views
122
iamchemist
iamchemist
MattGreer
  • Locked
  • Question
Enter Me.Date into a query triggered in a Form button 1
Replies
6
Views
59
MattGreer
MattGreer
bosk0
  • Locked
  • Question
Getting a syntax error in INSERT INTO statement 1
Replies
5
Views
83
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top