Utilizing Microsoft Access from C#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, I am trying to prototype a data import function, and the Data Import
Wizard from Microsoft Access is what we wanted to pattern our importer off of.

How do I get to this wizard inside the Access Data Model?

Thanks in advance,

Andrew S. Giles
 
Thanks for the reply!

Sorry to be confusing, I will elaborate.

We are trying to import data into our application. It comes to us in more
formats than I can shake a forest at. Therefore we need some way to get them
read into a standard-ish form.

Looking about, Access has this great little wizard that allows the user to
pick what type of file they are working with, what datatypes things are, etc.

As this is a prototype of what I _want_ to do, I wanted to just plug in the
Access version until I could have my own version completed, so Management
could see where I am headed.

However, I cannot seem to find this in the COM-exposed Access library.

Right now I have it added as a reference, and can see it... but I want to
find this functionality, can have managed to miss it if it is there.

When I put "using Access" into the main app, the app no longer compiles,
stating that Application is ambiguous, so I know I will need to preface
everything with Access. in order to get to them.

Any ideas on where to look?

I have a flat text file in 3 columns that I am testing on.

Hope that helps explain things a bit more.

Andrew S. Giles
 
Not sure exactly what you are after here...

But if you are asking "How do I programmatically manipulate MS Access from
C#?" then the answer is to add a reference to the MS Access COM library to
your project and then you can fo anything that the COM interfaces will let
you do...
 
Back
Top