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

Its been a while & i am rusty - need a button to import automatically

P: 56
I am trying to create a fool proof "import" button that will import data from an excel file that will be located on a shared drive. This file can be updated by users - but I don't want them to have to manually import the data to the database. I also do not want to link the table - since it will likely be a table that is often deleted and replaced.

So i need VB code that will enable a button to import the table - and overwrite the one in the data base.

I have a saved import - so if we can just point to that - that woudl be great. I plan to have numerous saved imports and rather than have my users go thru this list - I want to give certain groups access to certain imports.

table name is BLDG_INV
current location is d:\Docume~1\solivas\Desktop\DATABA~1\BLDG_INV.XLS

can someone please work some magic?

Thanks!
Mar 5 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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