Re: [MSAccessProfessionals] Does anyone have a command line script/module that will export a database as text to a directory?

Thank you for your inputs.

 

What I ended up with was:

 

I created the function that would copy each of the tables (40) and put it into the database.  I couldn’t call the function from the command line prompt so I then created a macro that would run the function.

 

(If I did the transfer to csv with a macro it didn’t hold all the required formatting.)

 

I then was able with the command line to open the database and the macro, and thus run the function.  Required a few more little touches (some timer delays, quit, etc.) but works like a top.

 

I would be happy to share the code if any would like it, although I understand it is a bit of an obscure problem.

 

Regards,

 

Patty

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Monday, June 8, 2020 3:51 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Does anyone have a command line script/module that will export a database as text to a directory?

 

Hi Patricia,

You could use the Windows scheduler on a PC to open and Access file that automatically does the exports and then closes. 

 

Duane

 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Patricia Mapes <patty.mapes@gmail.com>
Sent: Monday, June 8, 2020 1:27 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Does anyone have a command line script/module that will export a database as text to a directory?

 

Data only Duane.

File for each table.

If I use a recordset, which is something to think about, they will need to manually execute.  What they are looking for is some what to run this once every 24 hours.. or whatever their schedule is without necessary manual intervention.

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Monday, June 8, 2020 10:37 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Does anyone have a command line script/module that will export a database as text to a directory?

 

Hi Patricia,

Are you thinking only data? Field names or just records? A text file for every table? CSV or tab delimited?

 

Or, do you want the forms, reports, queries, modules, etc?

 

I expect you could create a recordset of tables and use some export functionality to do this.

 

Regards,

Duane

 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Patricia Mapes <patty.mapes@gmail.com>
Sent: Monday, June 8, 2020 9:14 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Does anyone have a command line script/module that will export a database as text to a directory?

 

Big order I know, but it has got me stuck.

 

Any and all ideas welcome.

 

Thank you,

 

Patricia Mapes

Senior Business Solutions Provider

603-748-2208