AutoCAD Map 3D :: Unable To Attach Excel / Access Files As Data Source
Dec 27, 2011
I'm fairly new to Map 3D and I'm trying to attach either an Excel or Access file as a data source. I started out with a simple test case and created both Excel and Access files following the steps outlined in the first reply in post:
[URL].......
When I get to the drag & drop step to attach the data I get the following error messages:
Invalid Wordspace file format: My DocumentsTEST.xlsx
Invalid Wordspace file format: My DocumentsTEST.accdb
Not to be deterred, I saved the source files back to earlier xls and mdb file versions and was successful at attaching the data in both cases, but Map reported that there were no tables when I tried to define a link template.
View 5 Replies
ADVERTISEMENT
Jan 18, 2012
i have 12 base maps (transportation.dwg, utilities.dwg, etc) and each of these base maps is attached to a data source (.mdb). when creating a new drawing and inserting these basemaps in the Task Pane by Attach Drawings & Query, i loose the connection to the data source in the new drawing
is there a way to have the datasource carry through and retain the attachment to new drawing?
also, in alot of maps we create we Xref (Transportation.dwg) and we loose the datasource in that situation too.
i'm new at this so hopefully my question makes sense.
View 9 Replies
View Related
Sep 15, 2010
I just upgraded to Civil 2011 from 2009 and a drawing I was working in, which had a database attached, is no longer working. Fine. I understand that upgrading may cause some things to not work properly.
So, I try to attach that same database and I get an error message that reads:Failed to create the data source file:
Database2
I tried creating a brand new database with newly imported information and it did not work. I tried creating a brand new database with no information , and still I get the same message.
View 7 Replies
View Related
Apr 25, 2013
I have create an excel file with a description and a hyperlink.With this way the user is able to open all the file that was able to open in only one excel.So far everything is OK.My problem is this. Have added 3 new lines for 3 different adobe illustrator files.When the user makes a click in the hyperlink open the adobe illustrator but is empty.They don't opening the file that has added in the hyperlink. (It happens only in the .ai files all the other files .pdf - .doc - .jpg opening without any problem)
I use windows XP with SP3 and adobe illustrator CS4
View 5 Replies
View Related
Jan 13, 2014
How can I update the data connection source for all the display map layers in my map layouts? If I want to change the shapefile a layer is representing I can not get the layer to point to the new shapefile.
The layer seems to always remember the name/location of the old shapefile. If I export the layer and modify the value in Notepad then load a new layer from the saved and modified layer file it will change. However I would have to do this for every layer I want to change.
Is there another way to change the property of this layer in AutoCAD?
Example: I create a drawing and layout with a Display layer that points to the FDO data for shapefiles "C:datauildings.shp".
I then give the drawing to another worker hows data is on "E:DATABUILDINGS.SHP" the data connection to the layer cannot be updated that I can see.
View 5 Replies
View Related
Feb 14, 2012
I'm trying to link excel to autocad for a time now.
and until now it didn't work for me.
Everytime it says "1 data link(s) do not allow their data to be written out."
thats when i try to write it to the excel file.
View 5 Replies
View Related
Apr 6, 2011
How to fix a broken link to an excel table in an idw file general table?I changed the folder name and heirarchy of the project.i expected the idw tables to find their parent excel files in the same folder with a new name, but they didn't.
I could find nothing for fixing broken excel links.
View 4 Replies
View Related
Jan 18, 2011
I keep getting this error when I try to connect to an .xls or .dbf file.
View 8 Replies
View Related
Sep 12, 2012
I am unable to write Tag data to NEF files with Elements 5.0 even though it says this is possible. I have just changed my laptop to a Windows 7 operating system. Will upgrading to 10
View 16 Replies
View Related
May 20, 2011
I've found a number of articles outlining the process of extracting data from AutoCAD to an Excel file, but I'm wondering if it's possible to do the reverse. For my work I have a number of databased already established in Excel and am able to create information tables rather quickly that access these databases. Currently, after creating a table in Excel I then copy, paste, scale to the right size in AutoCAD.
There's gotta be a way to create a table in AutoCAD that simply accesses this information in Excel and just updates automatically. I produce a number of CAD drawings off of a template daily so this process has become quite the bottleneck.
View 4 Replies
View Related
May 29, 2013
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
View 8 Replies
View Related
Aug 20, 2011
I have been unable to attach two pipes to a headwall. Tried to make the headwall wide enough but each pipe still overlapped. My current work around is to use two headwalls. Is there a way to get the double pipes with a single headwall? or am I stuck with two headwalls.
View 5 Replies
View Related
Mar 5, 2013
whenever I click to attach a drawing reference nothing happens. I don't get the browse to file window.
I've tried using the GUI from the View menu / Palettes panel/external palette, Also from the command prompt by typing external references and attach still no joy.
I have all SPs installed. I tried exporting another user's profile and importing it to my CAD. Do I have to reinstall the software from scratch?
View 4 Replies
View Related
Dec 10, 2013
I have an equipment list on excel 2013, that I can't insert into my AutoCad (2014) drawing. I've tried using paste special, paste link, using both as excel work book and as an autocad table. I have a wide variety of problems with both. Pasting as autocad table sometimes it wont update, when I try to update the link it locks up the drawing. When I paste as excel workbook it doesn't plot, although it show on plot preview. Is there a memory setting that has to be changed on autcad I have 12 gigs of memory on my computer.
View 5 Replies
View Related
Oct 6, 2013
Is there any way to determine the source drawing of a dref'ed object? I'm not seeing anything in COM or the .NET API's, hopefully I'm just not looking in the right place.
View 5 Replies
View Related
Aug 3, 2012
I have a 2011 Civil3D drawing with Data shortcuts in it. I need to replace the source drawing path of the data shortcut with another path. Is there a way to change this either manually or, preferably, programically. At some point we'll need to batch through the drawings and change this path information. Is this information is stored in a drawing dictionary somewhere? If so, where? If not, where?
Updating the .XML data files doesn't appear to affect data links already in the drawing.
View 9 Replies
View Related
Feb 14, 2013
I am having an issue with alignments not updating to the latest source drawing. Initially, the alignment source drawing was in File1.dwg. Due to a design change, a few of the alignments were revised in a new File2.dwg. For the first time ever, I used the Data Shortcuts Editor program to repoint the data shortcuts to the new File2 location. By all accounts, it looks like the data shortcut were updated to the new source drawing (File2).
The problem is in some files some of the alignments still source to the File1 location and even when manually synchronizing it still sources from File1. Additionally, it seems random in terms of which alignment and files source to File2, even to the point in some files one alignment will update to File2 and other won't and some alignments will update in some files but not all. Note that I am not the original creator of the files so I don't know much history on the files (no alignments seem promoted however).
What’s the best way for me to get all the alignments to point to the new data shortcut source drawing location?
View 3 Replies
View Related
Jul 12, 2012
It was in Feb - March 2012. I was then using AutoCAD Civil 3D 2012. I had faced a problem of getting ground data for a large surface by using satellite imageries processed by some government wing of USA (NASA?), have lost track of it.
View 6 Replies
View Related
Apr 18, 2012
I'm receiving this error will trying to export a clip from Smoke on Mac.
cannot access source clip/stonefs 7...
A weird thing is that I don't always get the error message. Sometimes the export works. But, more often it's not.
View 6 Replies
View Related
Oct 30, 2013
I am trying to attach a number of tiff files to individual dwg files. There are about 300 so I am writting a script that will open a new dwg, insert the tiff and save the dwg at a given name, so i have filedia set to 0 and everything is user input.
The problem I am having is that when I use the iinsert command and enter the path for the tiff I get this error: (filename)was not found or is not valid. This is pathed to a network drive. When I copy the same folder to my c: drive and run the command everything works as should. is there any reason for this?
When pathed to the c: drive and working correctly it looks like this:
C:UsershbrittDesktop11301 DCS Migration Phase 2 Execute Engineering Detail DesignDRAWINGSWORKING SETLOOPSDEMOD70-B-F101.TIF
When pathed to the network it looks like this:
G:EngineeringCURRENT JOBSMOTIVA11301 DCS Migration Phase 2 Execute Engineering Detail DesignDRAWINGSWORKING SETLOOPSDEMOD70-B-F101.TIF
I get this error:
G:EngineeringCURRENT JOBSMOTIVA11301 DCS Migration Phase 2 Execute Engineering Detail DesignDRAWINGSWORKING SETLOOPSDEMOD70 was not found or is not valid.
I noticed in the error message it cuts the end of the file name off. Is there a character limit?
I have done this before with a path to the network and everything worked as should. We have recently upgrade to 2013 but i would'nt think that would be an issue.
So basically, file on local drive everything inserts fine. File on network, get error.
View 3 Replies
View Related
Sep 18, 2013
I need to update both the path and the Source file name in Data Shortcuts editor. If I update the path, it looks in the new path for the old file name, and throws an error. If I update the File name, it looks in the old path for the new file name, and throws the same error.
View 6 Replies
View Related
Aug 9, 2013
I am reasonably experienced in coding in VBA but cannot find any references as to how to achieve the above within VBA so am now turning to LISP to see if I can achieve it in that language.
Basically I want to be able to create multiple instances of an attributed block using an external source, e.g. a spreadsheet to provide data for the attributes.
I'm not even sure if this is possible.
I can find lots of references for extracting attribute date to a spreadsheet but I want to go the other way!
View 2 Replies
View Related
Apr 19, 2012
Is there a faster way to create figure prefix i.e form excel spreadsheet or access.
I have one tip also. When you modify the figure database "C:ProgramDataAutodeskC3D 2013enuSurvey" by using notepad and you add "*" after each figure it will connect during linework codes that much the prefix code and will exclude the integer, EPN1 and EPN2 will be treated as EPN
The aterisks can not be added from the civil3d .
View 9 Replies
View Related
Jun 3, 2011
I am looking for a way to use the .dwg file properties of a drawing to generate an updateable drawing list/register. One that will update automatically as the file properties are updated. I have already created a title block that uses text fields to display custom properties of the file on my title block, such as the job no., drawing no. etc.
I have searched the web for answers, came across this site, joined and searched through it... There are a number of threads that 'sorta' deal with my needs but alway tend to digress more towards the "poster's" needs and away from mine. I noticed that they all talk about Lisp Routines and I have no knowledge of using them. Is that the only way to go or can I use another route? Another one was the Sheet Set Manager but I don't think that this is exactly what I am looking for...
View 1 Replies
View Related
Oct 22, 2011
I have been working in a 3ds Max 2011 file for a few days with a AutoCAD 2011 dwg linked. It has been working fine. I have just tried to reload the CAD file as I have been doing all along and it now has the error message "Unable to attach this file; the file may be missing, corrupted, or may not contain valid data".I have tried starting a new Max file and attaching various other CAD files but none will work, I get this error every single time.
View 2 Replies
View Related
Sep 13, 2013
I placed a watermarked image for review and now need to buy the real stock image, but have accidentally deleted the source file. Is the file data stored anywhere in Photoshop like a Link would be in InDesign?
View 3 Replies
View Related
Feb 12, 2013
Since updating to v4.3 I am unable to attach watermarks
View 3 Replies
View Related
Feb 20, 2014
InDesign and a multiple language data source.
I am not sure if this is possible with CSV, XML, MySQL, or if there is a third-party plugin available for this...but here it goes:
I have some data:
SOURCEDE_LABELES_LABELNL_LABELAppleApfelManzanaAppelBananaBananePlátanoBanaanCherryKirscheCerezaKersPearBirnePeraPeerGrapeTraubeUvaDruif
What I need to be able to do is insert the SOURCE fieldnames/placeholders throughout a document and then depending on what language I select (either through a text variable, or manual selection), the translated terms are automatically inserted in place.
View 4 Replies
View Related
Nov 8, 2011
I saw a youtube video "Cross Section in AutoCAD".But i could not understand how to transfer the data from excel to AutoCAD.There is a file TMaker.exe to make template of excel data.I could not find that elsewhere on net. Making earthwork x-sections with AutoCAD.
View 9 Replies
View Related
May 29, 2007
I have an excel file containing xyz co-ordinates that i wish to import to AutoCAD (2005).
I realise you can probably do this using the lisp function, but i don't know how they work, and wanted to know if there is an easier way.
View 9 Replies
View Related
Apr 6, 2010
I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.
View 9 Replies
View Related
