export to csv file

[louisa]

Hi everyone,

Im hoping to start an accounts database which will all be based in a datasheet view. When our accounts need to be filed im wondering if it would be possible to export all the data into a csv (excel) file?

Many thanks

 

[Bryan]

The data from any table can be exported to .csv format. If you database is relational, you may need to construct queries and then export the data from those.

If you're using Access 2010 (and possibly 2007???), you can export directly to an .xlsx format.

 

[Dreamboat]

Yes, also in 2007, Bryan.