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.

I forgot to mention that Access database is located on a shared folder on a network drive which in any case should not pose major problems. And to you Gene, can you elaborate a little more please how to get these done in Access without VB?? any samples, code , wizard etc?

Yes, at present they currently downlod the time/shift/names data from Kronos manually, then go to the shared drive where the Access is located, delete the old files, import the new ones, rename one of the files and then look at the reports. But even this is complex for a vast majority of line supervisors so we want an automated tool with one or two clicks..that is it. About Access Macros, is there some examples?

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.