How to: MS SQL to MS Access. Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats.

Microsoft Access is an reliable and easy-to-use tool for collecting and storing data such as customer contact lists, company inventory, personnel information and sales records. Information you ...

Then they're there, no one knows it, and you can use the full functionality of Access.<BR><BR>When you're done, you might do a benchmark between using the temp table versus sql server to see if it ...