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

Form Upload to Table

P: 1
I work in the Air Force....finance world and I think I have an idea of how to improve a process using access but I need some help.

What I would like to do is create a form that lets the user browse for an excel file, then will click an "import" button which then imports all the fields in excel into a table.

I'm not sure if this is possible or the easiest way to do this but I think it would help out our customers a lot.

Thanks!
Jul 18 '12 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
Please read thru the following thread:

Post 4 is what I think you'll be interested in:
http://bytes.com/topic/access/answer...te-access-info

It covers:http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

There will also be some concern about data validation; however, you should be able to handle that too...

-z
Always happy to help the military... Dad is retired MSGT-USAF and StepDad retired CPO-USN - Let me know how I can be of further help... on vacation the next few weeks; however, I have no fear that people here will take good care of you!
Jul 18 '12 #2

Post your reply

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