PDA

Click to See Complete Forum and Search --> : Convert Db Access to Excel


AM LOPEZ
Jan 11th, 2000, 12:46 AM
Hi everybody!!
I need to export an Access Db to an Excel file, something like a report, How can do a process to export a db to an Excel File directly?
I know that i can use a reference to Excel object but are there a simple method to do this?
Thanks in advance.
Regards!!

------------------
Angel Maldonado López.
Programmer
amaldonado@hotmail.com

Jan 11th, 2000, 01:11 AM
Yes.

Select File

Select SaveAs/Export

Select To An External File Or Database and hit OK

Chnage the Save As type to whatever version of excel you would like.



------------------
Boothman
There is a war out there and it is about who controls the information, it's all about the information.

AM LOPEZ
Jan 11th, 2000, 01:48 AM
It works fine in the Visual Data, but i need that my program do this.
Thanks!!!

------------------
Angel Maldonado López.
Programmer
amaldonado@hotmail.com