• Home
 · 
• Coding Standards
 · 
• Excel To Access

Excel To Access

by SSS (1 Submission)
Category: Coding Standards
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3^rd February 2021
Rating: (3 Votes)

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.

Download this snippet    Add to My Saved Code

Excel To Access Comments

No comments have been posted about Excel To Access. Why not be the first to post a comment about Excel To Access.

Post your comment