Export Access DB To Text For Move To Another Machne

[jkjSnake]

I'm trying to figure out how to dump an Access database to text so that I may regenerate (again in Access) on another machine. The dump to text is a hard,fast requirement. I've been able to programatically export the queries and tables, but having a tough time capturing the relationship, modules and macro information. Any help is greatly appreciated.

(Using Python ADO)

Thanks

 

[TheAceMan1]

How are ya jkjSnake . . .

I'm confused!

[blue]Whats wrong with zipping the db and unzipping in the final destination machine?

See Ya! . . . . . .

 

[jkjSnake]

The text needs to be analyzed prior to the move

 

[DrSimon]

How about this: You've got the bulk of the data out so why not copy the database, then empty all the tables and compact. You should then be able to copy out that db (or zip if there's loads of code) and transfer to other machine.
Simon Rouse

 

[jkjSnake]

I just ran across something interesting:
Application.SaveAsText acForm <form> <fullpathFilename>
Application.LoadAsText acForm <form> <fullpathFilename>
This should allow me to export/import to text Forms,Queries,Tables,Macros, etc.

Sounds too easy. I'll let you know.

 

[jkjSnake]

Well, Here's the result:
Both of the "SaveAsText" and LoadFromText" worked very well. (With the exception that I was unable to implement them using the python library. I had to do it in VB, but that's okay).
Now I'm only left with one problem...relationships. I'll post the code directly.

Thanks for listening to my ramblings.