Importing data from excel to an existing table in access database using visual basic 6

Question

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)

Posted 28-Jun-17 0:31am

Member 12492969

Updated 28-Jun-17 2:27am

Add a Solution

Comments

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 VB.net and Google for some snippets.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

CHill60 · Answer 1 · 2017-06-28T02:27:00

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