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 |
|
pMH
Starting Member
1 Post |
 Posted - 2004-09-30 : 20:47:29
|
| We have a SQL server running with our inventory items listed in there. We have queries setup in Access to run and create 'price lists' of the items in our SQL db. We enter new items through our third party software (iCode Everest) into the SQL db. My question is this...1- How do I export that new data in the db to the current TABLE in Access that the report query runs from?2- How can I update the TABLE to reflect the new items in the SQL db?There is something easy that I am missing. A previous employee used to be in charge of this and he made things quick and easy, but left without leaving notes as to how to do it.My main thing is how can I update the new info in the SQL db to my Access Table? Would DTS work? How does that work?Please shed some light on this issue for me as I am not too 'keen' on it at this point.Thanks for your help. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-10-03 : 19:26:19
|
| If you're just trying to re-synch the two tables, then the quickest method would be to:1. Open the Access db2. Delete the existing table3. Re-import using the New Table -> Import functionIf you need to do something a bit more complex, such as periodic updates or updates according to some rule, you might need to consider DTS. Can you post some of your predecessor's code for us to look at? |
 |
|
|
Shurgenz
Yak Posting Veteran
51 Posts |
Posted - 2004-10-06 : 00:22:38
|
| >>1- How do I export that new data in the db to the current TABLE in Access that the report query runs from?>>2- How can I update the TABLE to reflect the new items in the SQL db?Why do you need DTS?Try to make an adp project instead |
|
|
|
|
|
|
How Do I Export SQL data to an Access Table File