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\sol ivas\Desktop\DA TABA~1\BLDG_INV .XLS
can someone please work some magic?
Thanks!
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\sol ivas\Desktop\DA TABA~1\BLDG_INV .XLS
can someone please work some magic?
Thanks!