by Dave (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(8 Votes)
This code is used to convert entire Excel Workbooks to Access Databases. Each Excell Worksheet in the Workbook becomes a new Table in the new Access Database. This codes has a problem processing more than one file at a time without stopping and restarting the program. It looks as if it is processing the file but it never actually imports the next file's Worksheets. Try it and you will see what I mean. Any HELP would be appreciated.
Assumes
This program has problems processing multiple files with stopping and restarting the program. Any HELP would be appreciated.
Side Effects
This codes has a problem processing more than one file at a time without restarting the program. It looks as if it is processing the file but it never actually imports the next file. Try it and you will see. Any HELP would be appreciated.
VBcoders