Hi,
Can anyone give me some advise on how to do a bulk insert into an SQL Server DB from Access using DTS.
Thanksif you currently have data in the table try makeing a copy of the table and practice importing into that. just use the wizard and when you get to the select source table and view take time to look in the transforms and all the tabs. perhaps you should check the enable identity insert.
best way to learn it is to practice it a few times.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment