I've completed an initial mapping of the field types available in access and their corresponding matches in SQL server according to the built in Access XML Export tool.
It's available at
http://dfgintranet/Portal/LinkClick.aspx?link=683&tabid=614I've also collected some links relevant to creating/modifying databases via SQL code
http://www.islandman.org/umuc/ifsm410/DataDefinitionQuery.htmlhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asphttp://msdn2.microsoft.com/en-us/library/aa140011(office.10).aspx
and documenting with XML
http://articles.techrepublic.com.com/5100-6329-5035228.html
I have some code available for anyone interested in batch exporting their table schemas from an existing database, it could easily be modified to do the inverse too.
--
Alex Mandel
amandel@...
CA Dept. of Fish & Game
Resource Assessment Program (RAP)
916.445.4658
http://www.cdfg-rap.net
http://www.dfg.ca.gov/rap/ 1812 9th St.
Sacramento, CA 95811
