I have a client who wants to use my systems, but has to provide data for a parent company to analyse.

The parent company is happiest to receive the data in MS Access format. (Please don't ask why! )

I will not be exporting the whole EDB database, as the parent company only wants parts, but they don't want summaries ... they want "real" listed data. The database will contain 10,000s to 100,000s of records.

I have a nice DB framework with which I will build a Delphi EXE for the client. Ideally I would like to add code to this EXE (perhaps calling EDB functions where possible) to automate this data export process.

I know and use EDBs excellent EXPORT TABLE function regularly to generate simple CSV files which can be opened by Excel, but I haven't done anything similar with Access as a destination.

I really know very little about Access & don't even have it installed on my PC at present (this will have to change)!

Any pointers, can it be done directly, and gotchas?

Good components for Import of data into Access from CSV?

Good pointers for automating CSV conversion from Excel -> Access?

Adam


I have done something similar (its a few years ago now so the details have faded) but why not "simply" have a set of Access components as part of your program and write to the thing directly rather than a two step process?

Roy Lambert

Adam,

> Good components for Import of data into Access from CSV?

Have a look here:
http://delphi.xcjc.net/viewthread.php?tid=46318

or here:
http://www.torry.net/pages.php?id=555

Uli

On 6/9/2015 2:23 AM, Roy Lambert wrote:
> I have done something similar (its a few years ago now so the details have faded) but why not "simply" have a set of Access components as part of your program and write to the thing directly rather than a two step process?

I'll second that - have not used access for a while but you can use the
generic data access components for this. There used to be ado components
that were included with delphi (i assume still are).

You do need MDAC installed but AFAIK it's been included by default on
all OS's since XP.

Raul

Thanks for all of these responses, I think I will follow Roy's suggestion & try to work with a component within Delphi. I haven't worked with MDAC before ... but I'm sure its not too complicated

Adam


Once you figure out how to get the dear little Access database to connect its a doddle. My recollection was about 2 days finding how to do that and about 20  mins to do teh "real" work
Roy Lambert