John McCawley wrote:
> I think I may not have described my problem clearly enough...I
> *already* have a server-side app written in PHP with a Postgres
> backend...This is the ultimate destination of the data. The problem
> is that I am being forced by my client to deploy a 3rd party app on
> all of my field guys' laptops...This app (that I have NO ability to
> modify) is set in stone, I cannot use a different one or modify it. I
> am trying to write an app client side that exports the data from the
> .mdb backend of this 3rd party program and into my Postgres backend.
> This needs to work over the Internet, as my guys are not necessarily
> on my LAN.
>
> Believe me, you don't have to sell me on the benefits of web
> programming. What I am trying to do is work around the limitations of
> someone else's app. Everything that I have written on this project
> (with the eception of these "glue" apps) is PHP/Postgres.
>
>
Ok, then scratch the asp.net idea.
The other stuff is still good advice
With C# or VB.net you could use the ado.net driver to access the .mdb
files,loop through the rows, then use the NPGSQL .net provider to do the
inserts into the PG backend server for each row iteration.
You could even use Perl to do this pretty easily.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
