VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

Excel To Access

SSS  (1 Submission)   Coding Standards   Visual Basic 3.0   Intermediate   Wed 3rd February 2021

Extracts the Excel sheet data into the Access database file.

Inputs
Name of the excel file.

Assumes
Here in this code along with ADO, an extension of ADO ie. ADOX has been used. ADOX is the ADO extension for DDL schemas and security.

Side Effects
Few error handling is still remaining.

Rate Excel To Access (4(4 Vote))
Excel To Access.bas

Excel To Access Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters