Jump to content

Data Extraction to Excel turns data into dates.


arkitectin

Recommended Posts

Hello Everyone,

I'm using AutoCad 2014 and have Microsoft office 2007. I use attributes in every drawing. Most have identifications as 1-01 which stands for Floor 1-Item #01 or 3-27 which stands for Floor 3-Item#27. When I use the data extraction, I extract it to the drawing, everything is correct at this point. Then export to a CSV file. If I open the CSV file in Excel all of my attributes turn into dates 1-Jan or 27-Mar. If I try to turn the column back to general or text it becomes some 5 digit number. Is there a way to export the data into excel but it keep the formating of the data in Cad?

Link to comment
Share on other sites

Format your excel cells as text before you import the data, or if you use the excel import data wizard the third screen gives you the chance to select the type of data for each column (choose text).

Link to comment
Share on other sites

In CAD the columns were previously set to text which is why I couldn't figure out why they were becoming dates in excel.

 

I redid the data extraction. On Page 5 of 8, I right clicked on each column, selected Set Column Data Format and changed them all to General. On Page 6 of 8, I selected to Insert data and to Output data. Instead of trying to export the table from CAD to excel, I opened the Output Data file created in excel directly. It opened and all of my data was correct, it had not converted to dates.

 

Thanks for your help! :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...