export table question ?

[Dave Porter]

HI there,

I have an access database, but I need to export the data to csv or excel or
something generic, so I can read it into something else.

The thing is I do not have access installed on my computer - is this
possible.

Are there any free tools to do this - it is a one off procedure !

TIA - Dave Porter
HI there,

I have an access database, but I need to export the data to csv or excel or
something generic, so I can read it into something else.

The thing is I do not have access installed on my computer - is this
possible.

Are there any free tools to do this - it is a one off procedure !

TIA - Dave Porter

 

[Tom Wickerath]

Hi Dave,

If you have Excel, you can pretty easily import your data into Excel, and then save it out
at a text file. In Excel, click on:

Data > Import External Data... > Import Data...

At the "Select Data Source" dialog box, navigate to the folder where your .mdb file is
saved to.

Tom
__________________________________________


HI there,

I have an access database, but I need to export the data to csv or excel or
something generic, so I can read it into something else.

The thing is I do not have access installed on my computer - is this
possible.

Are there any free tools to do this - it is a one off procedure !

TIA - Dave Porter
HI there,

I have an access database, but I need to export the data to csv or excel or
something generic, so I can read it into something else.

The thing is I do not have access installed on my computer - is this
possible.

Are there any free tools to do this - it is a one off procedure !

TIA - Dave Porter

 

[Dave Porter]

Thanks to Tom I was able to use excel to import to excel using the 'database
query' facility.
cheers - Dave