>A few months ago I remember seeing an option in Microsoft SQL 2000's >Enterprise Manager that will easily import or export this type of data >between Access and MSSQL Server. I haven't used MSSQL for a few months >now, so I don't remember what this tool is called.
You mean DTS? Data Transformation Services. It should do the trick. Randall