How would I go about automating the export of an Access table to a dbase4 database? Any ideas?
Printable View
How would I go about automating the export of an Access table to a dbase4 database? Any ideas?
If you are in Access, and do not wish to use code, (VBA or VBx) you can perform the actions using a macro and the sendkeys command. I have a database where I do exactly what you want, except that I'm putting out RTF files from reports. In mine, I change the output name to reflect the differing targets of the reports. It works fine.
With that said, for most professional developers/users, SendKeys is not the preferred way to perform these actions for may reasons including the following:
1. Long, complicated strings cause Access to get lost.
2. There can be thorny sequencing issues.
3. The menu options can move. See Rename in Access2.0 vs Rename in Access97.
4. Techno-snobbery. Anyone can do it with little or no experience, so it can't be any good.
If you want, e-mail me at [email protected] and I'll send you a database example.
Good Luck
DerFarm
Anyone one know how to import export to dbase 4 through access? Something I read said something about transfer spreadsheets, but...
I still don't get it.
H E L P ! ! !