PDA

View Full Version : Access vs. SQL



bhargis
2004-12-09, 02:54 PM
I'm trying to link a few databases through VBA and Access is not a company standard, SQL is the standard Database here.

I know most, if not all, of the AutoCAD Databases are setup in Access. What is the best way to convert to SQL? or is there a conversion process and if so, are there any problems?

chatcher
2004-12-09, 03:20 PM
How did you connect to the Access Databases - ADO or DAO?

bhargis
2004-12-09, 04:01 PM
That's just it, I can't gain access to Access to be able to test the connection. So I need to be able convert the existing db's so that I can do some testing.

chatcher
2004-12-09, 04:29 PM
SQL Server has an import wizard for all types of data sets including Access.

But, you don't have to have Access to have access to Access. :)

jwanstaett
2004-12-09, 11:08 PM
you can use AutoCAD to look at your access database

_dbconnect

right click on data sources
select configure a data source

enter a name and click OK

select Microsoft jet on the provider tab

click on

Select the database

test connection

click OK

The data base is how in your data sources

Right click and select connect