You could use Access as the data repository and Excel as the client
front-end, using ADO.

http://support.microsoft.com/default.aspx?kbid=295646
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default.aspx?kbid=278973
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks


http://support.microsoft.com/default.aspx?kbid=257819
How To Use ADO with Excel Data from Visual Basic or VBA


Also see Carl Prothman' site
http://www.carlprothman.net/Default.aspx?tabid=81for connection strings.
MySQL even has an OLE DB provider so you can use that rather than ODBC
http://www.carlprothman.net/Default....oviderForMySQL




--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alen David" wrote in message
ups.com...
Hey Guys,

Thanks to everyone that gives useful advice on here ...

My issue is that I would like to be able to process an order form, and
finalize it by entering in a customer's billing information and having
it stored into a Access DB. Also if the customer is re-occuring, then I
would like to have it retrieve the customer information(I don't know
how) and populate all the billing/delivery information.

I understand that there are alot better ways of doing this out there,
unfortunately I donnot have the time, nor the budget.

Alen.

P.S.
As always any information is greatly appreciated.