Prev: Could not find stored procedure 'sp_MSins_XXX' - SQL Server 2000
Next: Merge replication problem - 3rd attempt to post
From: Malek on 23 Apr 2010 16:59
Hi,
if you got sql server, you can use integration services to export your data


"dba_222(a)yahoo.com" wrote:

> Dear Experts,
>
> I have an application that I've used for years
> that runs on Access under the covers. Help shows
> a reference to:
> Access 2002 Desktop Developer's Handbook
>
>
> It was a self contained application.
> All I have are the two MDE files.
> And they are full of data now.
> The app requires a login.
>
>
> I want to export this data into another database.
>
>
> How can I get the table structures and the data
> out of the MDE files?
>
>
> A new version of Access?
> Sql Server?
> ..NET?
> A data conversion tool?
>
>
> Oracle says that if they have the XML file
> with the table structures, they can export
> the data:
>
> http://www.oracle.com/technology/obe/hol08/sqldev_migration/msaccess/migrate_microsoft_access_otn.htm
>
> Is there a way to get the XML file
> from the MDE file?
>
> Thanks a lot!
> .
>
 | 
Pages: 1
Prev: Could not find stored procedure 'sp_MSins_XXX' - SQL Server 2000
Next: Merge replication problem - 3rd attempt to post