AutoCAD 2000/2000i/2002 Archive

AutoCAD 2000/2000i/2002 Archive

Reply
Active Member
jawisa
Posts: 9
Registered: ‎12-04-2000
Message 1 of 4 (314 Views)

Problems with dbconnect and excel

314 Views, 3 Replies
11-21-2000 05:18 AM
I am trying to use the dbconnect command to link date in an excel spreadsheet into my drawing. I have gone through all of the instructions in the acad_asi.hlp files to configute the data but it still does not work. Also, the jet_dbsamples file that is in the dbconnect manager dialog box does not work as well as all of toolbar in the dialog box. What is happening?
*Hub
Message 2 of 4 (314 Views)

Re: Problems with dbconnect and excel

11-22-2000 11:13 PM in reply to: jawisa
Probably you should install database drivers (dBase, Excel, ODBC etc.) Open
your windows control panel - there should be aplet ODBC. If not you must
run MS office setup and add drivers.

Hub

Uzytkownik "jawisa" napisal w wiadomosci
news:ef527f8.-1@WebX.SaUCah8kaAW...
I am trying to use the dbconnect command to link date in an excel
spreadsheet into my drawing. I have gone through all of the instructions in
the acad_asi.hlp files to configute the data but it still does not work.
Also, the jet_dbsamples file that is in the dbconnect manager dialog box
does not work as well as all of toolbar in the dialog box. What is
happening?
*Fleming, Jon
Message 3 of 4 (314 Views)

Re: Problems with dbconnect and excel

11-24-2000 12:12 AM in reply to: jawisa
ASI and dbConnect are two independent and different ways of connecting
to a database.

In Excel, set up your data in rows. Put column labels in the top row.
Highlight the rows, including the column labels, and pick "Insert"
"Name" "Define". Type in a name; this will be the name of your
"table".

In AutoCAD, pick "Tools" "dbConnect". In the dbConnect window,
right-click on "Data Sources" and pick "Configure data source". Fill
in a name and pick "OK". Highlight "Microsoft OLE DB Provider for ODBC
Drivers" and pick "Next". Highlight the "Use Connection String" radio
burton and pick "Build". Pick the "Machine Data Sources" tab and pick
"New". Pick the "User Data Source" radio button and pick "Next".
Highlight "Microsoft Excel Driver" and pick "Next". Pick "Finish".
Fill in a data source name. Pick "Select Workbook" and select your
Excel file. Pick "OK" until you're back in AutoCAD. In the dbConnect
window, right-click on the new data source and pick "Connect". Your
table should show up.

You will not be able to make changes in the table; the ODBC driver for
Excel doesn't support it.

There are other ways of setting up the connection in AutoCAD, but
that's my favorite.

If you still have problems, try downloading the latest MDAC from
http://www.microsoft.com/data and installing it.

This subject is usually discussed in the autocad.connectivity
newsgroup.

jrf
Member of the Autodesk Discussion Forum Moderator Program

In article , Jawisa wrote:
> I am trying to use the dbconnect command to link date in an excel
> spreadsheet into my drawing. I have gone through all of the
> instructions in the acad_asi.hlp files to configute the data but it
> still does not work. Also, the jet_dbsamples file that is in the
> dbconnect manager dialog box does not work as well as all of toolbar
> in the dialog box. What is happening?
>
*Fleming, Jon
Message 4 of 4 (314 Views)

Re: Problems with dbconnect and excel

11-24-2000 09:05 PM in reply to: jawisa
I should clarify "You will not be able to make changes in the table;
the ODBC driver for Excel doesn't support it.". The Excel driver does
not support making changes row-by-row in a displayed table. It does
support making changes by running SQL statements such as "INSERT ...",
"UPDATE ...", and "DELETE ...".

jrf
Member of the Autodesk Discussion Forum Moderator Program
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.