AsifMughal
asked on
Converting a SQL Server 2000 Database to Access 97
Hello All
Is anyone aware whether it is possible in VB code to convert just the data tables of a SQL Server 2000 database to a Access 97 mdb file.
I wish to use a small-subset of the SQL Server database in a Access 97 format.
I look forward to a reply.
Many Thanks
Asif Mughal
Is anyone aware whether it is possible in VB code to convert just the data tables of a SQL Server 2000 database to a Access 97 mdb file.
I wish to use a small-subset of the SQL Server database in a Access 97 format.
I look forward to a reply.
Many Thanks
Asif Mughal
Keep in mind that the stored procedures will not transfer over. I do this with an Access 2k database however it's a dump of the tables and table data.
More than likely you will get a few errors when you run it the first couple of times... if you need help with one just tell me what the error message is....
More than likely you will get a few errors when you run it the first couple of times... if you need help with one just tell me what the error message is....
ASKER
I am aware you can do this via DTS using the Enterprise but I need to do this via code, as I am using a mini version of SQL Server (MSDE).
I would like the user to click a button and it should automaitcally do this.
I would like the user to click a button and it should automaitcally do this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi AsifMughal,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept inthedark's comment(s) as an answer.
AsifMughal, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept inthedark's comment(s) as an answer.
AsifMughal, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
per recommendation
SpideyMod
Community Support Moderator @Experts Exchange
SpideyMod
Community Support Moderator @Experts Exchange
Enterprise Manager...
Right click on database.. choose "All Tasks -> Export" Follow the wizard.
Oh you need to create a blank access 97 database before you run it.