How do you use VB to use an Access Database which is importing dbase III .dbf files from a timeclock software?

Question

There are two pieces of software. (1) Kronos which collects the time data and store in .dbf files. (2) An Access database which imports these files (they have to be done manually everyday after deleting the old files from yesterday). Access .mdb database has multiple queries and reports based on these tables. Now, the question is how do we automate the process for average supervisor with no IT experiece so that she can click on a button-import .dbf files (and replace the old ones) to Access and look at the various reports based on multiple queries? Any suggestions? Is it better to do it using VB and ADO.NET or there are simpler ways of connecting these two existing programs? From Kronos, one has to manually create those .dbf files which is not a problem. The problem is to import those files in Access by click of a button and produce the reports.

Answer 1

I don't have Access on this computer so I can't verify this but...Can't you just create a macro that imports the .dbf to Access? Or train the supervisor to open Access, go to file>>import and select the correct .dbf file.



UPDATE

try this macro tutorial

http://www.er.uqam.ca/merlin/xw999998/eng/eaccm.htm

Answer 2

I've set up a demo DB and instructions on how to make a macro that will import your files automatically, as well as a switchboard that gives it push-button operation.



Download from here:



http://rapidshare.com/files/10215254/ImportDBF.zip.html

Answer 3

you're no longer giving me lots to artwork with right here m8, an errors message description or huge type would help, yet frequently i think of you will desire to verify the database record is in the comparable folder because of the fact the executable, and it would be a extra constructive programming prepare to variablize each and everything, from the direction of the MS get entry to record to the names of the tables and the fields...etc. additionally, once you moved this technique to a various laptop, did you progression it as an installation equipment or purely replica/paste from one laptop to a various?

Answer 4

You can do all of it in Access directly. No need for VB, ADO, etc.