Text to MSAccess DB

I can place data from a form into a MSAccess DB (firstname,lastname etc)

BUT is it possible to read text (client) and place it in a (server)MSAccess DB.

EG. A store may create a text file to store itmes in, like a basket, then send the item details to an order Table in Ms access, once the details are verified.

The intention is to create client side text file (possibly cookies) but send the details to a server side DB.

Please help.

Are you wanting to do this from a web-interface or separately?

Easiest way would be to run an import routine from within Access itself.

If you wanted to do it through the web, you can read in details from a text file using the FileSystemObject (as snooper stated) or you can actually connect to it as if it were a recordset using the OLEDB or ODBC driver. Once you've read it in it is easy to save it to the database.

Cheers,
Andrew