how to pass data that i get from another computer to my database instead of to a text file?
-
hi im using MS access as my database... i've to receive data from another computer and store the data in my database... initially, both computers were using string for read and write... my computer would get the data and store them in a text file... but as the data will keep on increasing and it is a huge amount, as well as for better layout, my computer will now use database to store data instead of in a text file>notepad... the codes used in the other computer is in string and i will NOT be changing the codes in that computer.. im not sure how a computer using string to read and write data will be able to pass data successfully to a computer using varchar for database.. i know i can use a wizard to convert data in text file to table form in database.. but what i want to do is to pass the data directly into a database from the other computer without having the user to need to use a wizard.. the user is supposed to click on a button in a form in my computer and the data will be retrieved from database for user to view/update... my question is: how do i write/change my codes in MY computer in order for the data passed over to directly be stored in a database? (the data will not be kept in text file any more..) thanks a lot!
-
hi im using MS access as my database... i've to receive data from another computer and store the data in my database... initially, both computers were using string for read and write... my computer would get the data and store them in a text file... but as the data will keep on increasing and it is a huge amount, as well as for better layout, my computer will now use database to store data instead of in a text file>notepad... the codes used in the other computer is in string and i will NOT be changing the codes in that computer.. im not sure how a computer using string to read and write data will be able to pass data successfully to a computer using varchar for database.. i know i can use a wizard to convert data in text file to table form in database.. but what i want to do is to pass the data directly into a database from the other computer without having the user to need to use a wizard.. the user is supposed to click on a button in a form in my computer and the data will be retrieved from database for user to view/update... my question is: how do i write/change my codes in MY computer in order for the data passed over to directly be stored in a database? (the data will not be kept in text file any more..) thanks a lot!
nidhelp wrote: im not sure how a computer using string to read and write data will be able to pass data successfully to a computer using varchar for database.. Make sure your varchar is as long as the longest possible string you'd pass in. That's it. nidhelp wrote: but what i want to do is to pass the data directly into a database from the other computer without having the user to need to use a wizard.. Do you know any SQL ? What you're after is a simple INSERT. nidhelp wrote: my question is: how do i write/change my codes in MY computer in order for the data passed over to directly be stored in a database? (the data will not be kept in text file any more..) Connect to a database with a table that has a varchar value, and do an INSERT into it. Do you intend on making this data easy to search in any way ? Will you at least put a datastamp on it ? Christian Graus - Microsoft MVP - C++