Hi, i need to know how to convert ms access database to work on sql. Any help would be appreciated.
Depends on Access and SQL. What version of Access and what version of MS SQL?
There are tools available to do the import for you.
im using ms acces 2005 and sql developer. im not too sure on the version i'll have to check.
ive tried to find tool, but at the moment have not had any luck, can you please advise on some?
thankyou for your replies
The versions matter. For example, if you have SQL 2008 installed, there is an import/export utility you can use to easily import an access database. see: http://msdn.microsoft.com/en-us/library/ms140052.aspx
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.