populating database from another database

[sp00k]

Populating an access database from another access database, Is this possible in access? If so how can you do it?

My one database has dates of equipment received(no internet there)
So i bring it back and my other database has a section for when the equipment was received. I would rather have a sql statement update it rather then doing it by hand.

Thanks!

 

[fermunky]

I think the short answer is Yes, and many possible ways. I think the easiest way would be to initiate the transfer of data from the destination DB. You could probably write some code to simply Import the tables from the source and appending it to the existing table on the destination. Or, you could even link the source table, and that way a query can just take the records from the source and append it to the table in the destination.

Unfortunately, I do not have any examples to give you, but those are just a couple options to think of.

 

[sp00k]

Thanks a lot! that gives me a few ideas. If i need anymore help I'll let you know!

 

[fermunky]

It may be simple enough to do with a macro. being new to this board though, I am not sure how liked the use of Macros are Good luck

 

[MSAccessRookie]

It may be simple enough to do with a macro. being new to this board though, I am not sure how liked the use of Macros are Good luck

Welcome to the board and thanks for offering great advice to a user with a problem. What you say about Macros is true. They are very useful and can do what the user wants. Most of the experts here seem to prefer Visual Basic for the reason that it can do everything that Macros can, and you have much more control over the operation of the process. The built-in error handling was what sold me. Speed is another consideration. Most Visual Basic Procedures run faster than Macros doing the same thing. I am sure that there are even more reasons, but here are two good ones.

 

[sp00k]

I have used a few macro's (pretty much just runCommand). I have a lot of experience with C# and visual basic seems very different from that. I guess I would have to ask the Visual Basic forum. As I don't know how to implement code (lets say Date) into a control I have on my form (called getDate). Perhaps marco may be better, but not sure which one to use.