Importing Data from MS Access to SQL Server ...

If u want to import data from MS Access to SQL Server ....

please refer this link ...

http://www.microsoft.com/technet/prodtechn...access.mspx#EGC

go to SQL server Enterprise manager

1. Select a database and right click and u w'l find All Task --- > Import data
2. Select a Source Database in our case .mdb ( access database )
3. Select a Destination Database ... in our case SQL server db ...
4. Check the radio button Copy Table(s) and view(s) from the source database ..
5. Click next next and Finish .... done

you may get this Error during import ...

---------------------------
Copy Data from tblMembers to [asny].[dbo].[tblMembers] Step
---------------------------
Error at Destination for Row number 446. Errors encountered so far in this task: 1.

Insert error, column 9 ('mainDateThrough', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.

Reason for this Error is Access automatically convert all datatime to smalldatetime in SQL Server ... so if Access table have some invalid dates it may difficult to covert by SQL server ....

Solution First u create a table ( which table have this error during importing ) in SQL server make all Date Fields in DATETIME .. dont keep in smalldatetime

and then import that particular table from Access to SQL server through DTS the problem will be solved .....