0

I want to manipulate imported data from Access in Excel and send back additional data to Access mdb database. Is this feasible?

denfromufa
  • 5,610
  • 13
  • 81
  • 138
  • The answer would be yes, but how much time are you willing to give to the issue, and what have you tried? [ask] – SeanC Apr 10 '13 at 13:32
  • As I mentioned below the plan is to use DAO/ADO in VBA + some SQL statements if necessary – denfromufa Sep 24 '13 at 14:13

2 Answers2

0

If you are looking for a place to start, you can:

1. Record a Macro
2. Do one manual import and manipulation
3. Stop the recording

and basically there you have the fundamentals of the code you need to do the rest.

Aaron
  • 132
  • 2
  • 3
  • 17
  • Excel does not support export to Access (at least without VBA), only import is available! – denfromufa Apr 10 '13 at 18:05
  • Fair enough. And after step 3 from the above suggested starting place, you can look to append your Macro created VBA code with the code found at: http://stackoverflow.com/a/11334263/1851961 . Does that help ? – Aaron Apr 10 '13 at 18:50
0

Microsoft office provide these two database management system access and excel both plays the vital role in database. Yes, you can easily import the access in excel without any VBA code with same database.

By reading the article I got the answer of the following query and easily http://gallery.technet.microsoft.com/Access-To-Excel-Converter-00660936

import the data into excel sheet. You just have to read the article.

user2168426
  • 1
  • i'm aware of import functionality in excel from access database. I need reliable and fast technology to put data back to Access from Excel. I'm thinking of DAO right now. – denfromufa Apr 19 '13 at 14:07