Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Export Access DB To Text For Move To Another Machne
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...- jkjSnake
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Export Access DB To Text For Move To Another Machne
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
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Export Access DB To Text For Move To Another Machne
The text needs to be analyzed prior to the move- jkjSnake
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Export Access DB To Text For Move To Another Machne
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...- jkjSnake
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
