Another scenario in Excel Application

Question

0.00/5 (No votes)

See more:

, +

Hi Code project Readers,

Since I'm a newbie in programming I couldn't find the solution for the below problem.

Please help me in this.

I have an autogenerated Excel (Excel - 1), Manually created Access and Excel (Excel 2).

the problem is when i click on Import Button in Excel - 2, I dont know how to import the data from Excel -1 to Access using macros.

I searched in google for several hours but couldn't find the solution. Please help me...

Thanks in advance.

Posted 25-Apr-13 20:10pm

Velrats

Add a Solution

Comments

Maciej Los 26-Apr-13 2:53am

Please, be more specific and provide more details.
Which version of Excel, Access?
Why do you want to export from Excel to Access?
Have you tried import data from Excel to Access?

Velrats 26-Apr-13 3:07am

The version of Excel and Access I'm using is MS Office 2010.

I want to export the data from Excel from Access because the excel is autogenerated and needs to be formatted to the required Report generation. So the data has to be transferred to an Access and has to be processed for generating a Report in another Excel.

For More information please don't hesitate to ask questions, so that there is more clarity .. :)`

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)

Maciej Los · Answer 1 · 2013-04-25T21:06:00

Solution 1

Change your scenario ;) and import data to Access from Excel using Access database. It's easiest way.

Import Excel data to an Access database[^]
Import, export, and link data between Access and Excel[^]
vba - Import Excel data in Access[^]

But if you want to use Excel, please provide more details (version of application, example data, etc).

Posted 25-Apr-13 21:06pm

Maciej Los

Comments

[no name] 26-Apr-13 3:42am

my 5 :)

Maciej Los 26-Apr-13 3:43am

Thank you ;)