How to move geographical data from MS Access to SQL Server
I would use VBA to construct &amp; export your spatial data into the Well Known Text (WKT) format. SQL Server supports importing data from this format &amp; as it is text based it is fairly easy syntactically.