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

Import Excel SS into Access

P: n/a
I have read through pages of responses and perhaps I missed a
solution... but here is my issue: I have setup a Access database to
track sales for our company and want to send out a shell Excel
spreadsheet to CS reps to fill in their monthly billing, they will
then send these files back and I will import.

I seutup the database and the Excel spreadsheet leaving the first
column blank to allow for the autonumber primary key in the DB. I
imported and had no problems... then I tried to import a duplicate
copy of the SS under a different filename and could not get it to
upload. I tried all possibilities I could think of and can only get
the database to accept uploads from the original SS. Help?

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.