Thanks gocush,

I think that will work, I don't have nearly that many records. Do you use
coldfusion, I will be.

Thanks,
Todd

"gocush" wrote:

Todd'
you asked about using Excel as a database alone w/out Access.
What is the max # of records and fields would you have in any table?

I have an excel "db" with 65000 records and 39 fields that I can sort,
filter,search,add/delete/edit records.

Does this meet your requirements?

"Todd Hudson" wrote:

That may be possible, however, I run the query every evening and would like
the info to be transferred directly to the access database. Otherwise, is it
possible to use excel as a database in coldfusion? If that is true, it would
be much easier just to use the excel file as a database.

"Tom Ogilvy" wrote:

In access, can't you link to an excel range and create a database from that?

--
Regards,
Tom Ogilvy


"Todd Hudson" wrote in message
...
Is it possible to have an access database updated from an Excel
workbook/worksheet. I want the database to be updated everytime the Excel
file is updated. Or, is it possible to create an access database that
will
include the web queries that are created in an excel file?

Thanks