VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

Excel2Access File Converter

Dave  (2 Submissions)   Databases/Data Access/DAO/ADO   Visual Basic 3.0   Intermediate   Wed 3rd February 2021

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.

Rate Excel2Access File Converter (8(8 Vote))

Download Excel2Access File Converter

Excel2Access File Converter Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters