Re: Access 2.0 to Oracle?

Robert,

About a year ago I was in the same situation of needing to upload an Access database to Oracle. Our budget was $0 at the time, so we didn't even look around for 3rd party products. We only had about 20 tables to do, so it wasn't worth it to get new software.

After some trial and error, I finally ended up saving all my Access tables into Excel spreadsheets and using ODBC and VBA to load Oracle tables directly from Excel. I did this because the VB functions in Excel were much easier to use (my own opinion).

It worked pretty well and I have the code you could take a look at if you want. I actually enhanced this code to allow users to load their own test data from Excel spreadsheets directly into Oracle tables. This saved our DBA group from having to write SQL scripts or .ctl files to do data loads.

Access 95 may have more robust support for communicating with Oracle via ODBC.

Thanks

Nathan

Evolving Systems, Inc.
nsecrist_at_evolving.com

Robert K. Brown wrote:
>
> Question: are there any tools that might help in the conversion of an
> Access 2.0 database to Oracle (ala the SQL Upsizing Tools from Microsoft)?
>
> All that would need to be converted would be a back-end database (no forms
> or code). There is a front-end Access 2.0 application that would then use
> ODBC to get to the Oracle data. I'm primarily concerned with the back-end.
> If there are no utilities, does anyone know of any articles, help files, or
> other documentation that would detail differences between field types, data
> types, etc?
>
> Thanks for the help.
>
> - Robert K. Brown
> rkbrown_at_skypoint.com
Received on Wed Apr 16 1997 - 00:00:00 CEST