C.J. Cunningham
|
| Posted: 01/08/2002, 2:33 PM |
|
I would like to update database records based on values in an ASCII text file that I upload to the server. Right now I do this using an update query created in MS Access on my desktop, then upload the updated database to the server. As the database grows this is getting more cumbersome.
Can I call an MS Access query from an ASP page?? Any help would be great. My evaluation version of CC is almost expired and this is my last major issue before I make my purchasing decision.
Thanks,
C.J. Cunningham
|
|
|
 |
James
|
| Posted: 12/23/2002, 3:02 PM |
|
|
|
|
|
James
|
| Posted: 01/11/2003, 4:57 PM |
|
?
|
|
|
|
Mehmet Ozdemir
|
| Posted: 01/12/2003, 1:24 PM |
|
You could always use the Text Provider under ADO to read the ASCII text file (I'm assuming that it is in some delimited format), then just treat the acsii file as a recordset loop thru it and update the values in your access database.
This could easily be incorporated into a CCS page.
Regards
Mehmet Ozdemir
|
|
|
|
JamesR
|
| Posted: 01/12/2003, 6:10 PM |
|
Mr Ozdemir
Thanks for the explanation ..but its way over my head.
Any possiblity of an idiots guide how to do this
Thanks
JamesR
|
|
|
|
