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