Click here to Skip to main content
15,846,038 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Am a beginner in vb6 with a little knowledge of Access. I would like to import some record from an Excel (Spreadsheet) file into a Table in an existing Access Database every month.

The Excel file serves as the monthly source data consisting of over two hundreds records. One of the table on the database will be updated (Append not Over-write) on a monthly basis by the source data received in form of Excel. The ID field on the table can accept duplicate value, and both the Access table and the Excel sheet has the same number of columns and datatype .

Please guide me on how to do that with a code to be used in a click event of a command button placed on a form to perform the action require.

Thanks for your anticipated help.

Amieen Designer

What I have tried:

I tried some codes i downloaded from other sites but could not achieve the desired purpose. Most of the code are in form of macros in excel or access. (VBA)
Updated 28-Jun-17 3:27am
Michael_Davies 28-Jun-17 7:02am    
Why VB6, VS 2017 community edition is free and better equipped for the job.
Maciej Los 28-Jun-17 7:21am    
VBA or VB6? It makes the difference!
KarstenK 28-Jun-17 7:58am    
You shouldnt develop on the old vb6. Learning and writing code for that legacy system is a waiste of time. Use and Google for some snippets.

1 solution

The code for the Access or Excel VBA should convert quite reasonably - just paste it into VB6 and fix any compile errors as they come up.

Ideally you should drop the use of VB6 at your earliest convenience (most people did this a couple of decades ago)

Use a more modern language, a .NET language such as VB.NET or C# and you will find several hundred examples of how to do what you want in either of those languages with an appropriate google search.

We can't help you much further because you have not shared any code with us - we do not write the code for you, we just help out with specific problems
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900