Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-07 : 09:55:34
|
| VIJAY writes "Dear Sir,Can I expect a solution to the following problem:A retail drug store run by me using a software that has VB and MS Access as the front and back ends respectively is now in the process of shutting down. I am moving all the stock from my store to an in-house drug store inside a hospital where another SW which also has VB and MS access as the front and back ends respectively is in use. In this situation is it possible to upload the stock data from the SW in my store to the SW in the other store where the stock is being moved to. I believe it is possible. If possible, how do I go about it? And also how to mark out the stock that is being added to the existing stock in the hospital drug store.Thanking you and looking forward to your reply.Regards.Vijay Menon" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-07 : 10:37:51
|
| It will be much easier if we got to know the layout of the tables that the data is stored.Peter LarssonHelsingborg, Sweden |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-09-07 : 10:42:37
|
| If the schemas of the databases do not match, then you will need to hire an Access dba to do this for you. |
|
|
|
|
|
|
DATA TRANSFER FROM ONE MDB TO ANOTHER MDB