Automate Access actions

[James Stanich]

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

[James Stanich]

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 ! ! !