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!