Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: RichWallace
- Order by date
-
Loading Access MDB Target from SQL source
Got it...created an Update Strategy and set my Workflow property on the Target to 'Update as Insert'.- RichWallace
- Post #2
- Forum: Data Management Tools general discussion
-
Loading Access MDB Target from SQL source
I have an Access 2000 MDB as my target that I need to populate from a SQL Server Source table. The target tables have columns that are SQL reserved words (Name, Number). How can I perform the INSERTs correctly in my scenario? I receive the following error currently.... WRITER_1_*_1> WRT_8229...- RichWallace
- Thread
- Replies: 1
- Forum: Data Management Tools general discussion
