By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,632 Members | 1,499 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,632 IT Pros & Developers. It's quick & easy.

need help...putting Excel Worksheets in Access

P: 175
is there a way to put a worksheet ( or multiple worksheets ) from Excel into Microsoft Access? I don't want to put one predetermined sheet into Access, I want Access to be able to load the correct sheets each time I use it ( I know the name of the sheets, and can write the code for it, but I'm not familiar AT ALL with how to move stuff from Excel to Access). Any help is appreciated.
Mar 22 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 2,364

You may be closer than you think. Assuming I know what you are attempting, you will not need to write actual code to do this:

(1) You can go right in access
(2) Hit New to make a new table
(3) Choose Import
(4) Find location of your Excel file
(5) Select the proper sheets to upload/import

If this is not what you need to achieve and please stay tuned. You should also consider adding a post in the access forum for adde support.

Have fun!

Mar 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.