Normally one uses ODBC to push the tables & data from Access to Oracle. = But I highly recommend NOT doing that. Access will create it's objects = in a case sensitive and non ANSI standard way. Create the tables = manually & then push the data in by linking the new tables. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Birkir Bjornsson [mailto:birkir@xxxxxxxx] Sent: Wednesday, September 29, 2004 12:16 PM To: oracle-l@xxxxxxxxxxxxx Subject: Converting MS-SQL schema file to Oracle schema file =3D=20 Hi=20 =20 I was asked to convert an MS SQL Schema file to an Oracl=3D e = Schemafile. Does anyone of you know of a tool to do it or shall I do it by hand?=20 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l