×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Importing attribute information to SQL data base

Importing attribute information to SQL data base

Importing attribute information to SQL data base

(OP)
We currently export attribute information into excel. Does anyone have any recommendations on exporting to access or SQL database?

RE: Importing attribute information to SQL data base

I have done all of database routines (whether Excel, SQL, or Access) with ADO. Makes it easier to switch between data types if you have to.

"Everybody is ignorant, only on different subjects." — Will Rogers

RE: Importing attribute information to SQL data base

(OP)
Hi borgunit
Can you explain some more? is the information exported able to be imported back into the drawing attributes? do you know of any software that does this?. We currently export to excel and then back into the drawing succesfully, but we a wanting to take the next step and use access or another sql data base.

RE: Importing attribute information to SQL data base

I do not know your programming knowledge level. I am referring to accessing the info from a vb routine in AutoCAD. If you cannot program then you may be limited to hiring someone to do this for you. As an alternative, if you have Express tools,  it has a few routines to Import/Export attribute info.

"Everybody is ignorant, only on different subjects." — Will Rogers

RE: Importing attribute information to SQL data base

(OP)
Haven't done much programming for ages (wrote a ton of lisp routines back in the early days of Acad). Currently doing a lot of reading to gain some understanding of visual basic, Im trying to teach an old dog a new trick. Im assuming I will have to write a specific routine?.
The express tools are too limited for what we require and to be perfectly honest are very crude. We currently use a third party application called Excellink which exports & imports backwards and forwards from autocad & excel very successfully but we would like to pull the information to a data base to be used in a number of other areas of the business.
Do you know of any third party software out there?

RE: Importing attribute information to SQL data base

Hi cadace,

I'm too sure of any software you can purchase to do what you want, but this is a FAQ I wrote on exporting the attributes out to an Access database (http://www.tek-tips.com/faqs.cfm?fid=5800), going the other way isn't too difficult.  Take a look and if you need any more help by all means post back.

HTH
Todd

RE: Importing attribute information to SQL data base

(OP)
Thanks TCARPENTER1
Checked out your FAQ, great insight and well worth posting the information. Spent the last few days crawling the net and playing round with some code, getting a feel for it now. The only problem is its given me other ideas. I hope I haven't created a monster.
Thanks again.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources