Text to MSAccess DB
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=127
Printed Date: 28 March 2026 at 9:01am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Text to MSAccess DB
Posted By: steveide
Subject: Text to MSAccess DB
Date Posted: 13 February 2003 at 8:39am
|
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. ------------- I know nuthin 
|
Replies:
Posted By: snooper
Date Posted: 13 February 2003 at 9:47am
| i haven done anything like this before, but i recall reading somewhere that you can do it using FileSystemObject (providing your host supports this) - and then you can read line by line from the txt file, and insert it into the DB. |
Posted By: Bunce
Date Posted: 13 February 2003 at 6:40pm
|
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, ------------- There have been many, many posts made throughout the world... This was one of them. |
Posted By: steveide
Date Posted: 16 February 2003 at 7:02am
|
Thanks But I've fixed it HERE IT IS.. My DB. table was named .... 'order' BAD MOVE SQL must use the word 'order' as a key word and I used it as a name for my table so the SQL script 'INSERT INTO order values... etc,etc' FAILED, so I renamed the table to 'ord' and HEY! it worked. HOW DUMB IS THAT.. I spent days agonisineg over this silly error, but I'm on my way again ..waiting for the next problem to stop me in my tracks. MANY MANY thanks for all your time and efforts. STEVE. |
