I need to automate the importation of Access tables into SQL Server. The Access database(s) are sent in on a regular schedule and I need to bring the data into SQL Server. I am not as familiar with bcp as I would like (I assume this would be the best tool to use). Any help on this would be appreciated.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.