Question Access - Export to CSV file (1 Viewer)

bhagyashri

New member
Local time
Tomorrow, 01:02
Joined
Feb 26, 2015
Messages
1
Hi Guys,

I have an existing Access Database which has a lot data, new records get added every day and a few are modified as well.

I need to write a script/query/exe which will get modified records(since last execution of same script etc.) from Access and export them to a CSV file.

My problem is getting those modified records.. Is there any default timestamp field in Access which can be used? Or do I have to add a new timestamp column for every table?

Any suggestions?

Regards,
B
 

namliam

The Mailman - AWF VIP
Local time
Today, 21:32
Joined
Aug 11, 2003
Messages
11,695
No such default timestamp unfortunately, it doesnt exist in most databases by the way.
You will have to create a modified column for each table
 

Users who are viewing this thread

Top Bottom