AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Export to Access or Excel

4 REPLIES 4
Reply
Message 1 of 5
KrisAugustyniak
233 Views, 4 Replies

Export to Access or Excel

In schematic reports (Report Generator :PLC I/O, AutoCAD 2008) I can see all information from I/O drawing but when I save that report to file with .xls or .mdb extension some address are not there. I don’t have that problem when I save it to file in ASCII or CSV format. Is this a bug? Is there anything I am not doing correctly? Any help would be greatly appreciated.
4 REPLIES 4
Message 2 of 5
Anonymous
in reply to: KrisAugustyniak

Can you please send me your drawing and let me know the steps you take to
get the error?

Thanks,
Mei

wrote in message news:5720322@discussion.autodesk.com...
In schematic reports (Report Generator :PLC I/O, AutoCAD 2008) I can see all
information from I/O drawing but when I save that report to file with .xls
or .mdb extension some address are not there. I don't have that problem when
I save it to file in ASCII or CSV format. Is this a bug? Is there anything
I am not doing correctly? Any help would be greatly appreciated.
Message 3 of 5

Hi Mei,
There are the steps to get the files reports from my drawing:
Menu Projects : Reports / Schematic Reports
Report Name : PLC I/O Address and Descriptions (Active drawing) - OK
(I can see all information – 38 records)
1. Save to File : CSV comma delimited – OK –> PLC.csv
(I can see all information – 38 records)
2. Save to File : Excel spreadsheet – OK –> PLC.xls
(I can see only 30 records, there are inputs missing :X02, X03, X04, X06, X10, X11, X12, X20, X21)
See the files attached: PLC.dwg, PLC.csv, PLC.xls
Thanks,
Kris
Message 4 of 5
Anonymous
in reply to: KrisAugustyniak

Hi Kris,

Can you please download and install SP1 in the following link and see if you
still have the same problem?
http://usa.autodesk.com/getdoc/id=DL10091271

Thanks,
Mei

wrote in message news:5721230@discussion.autodesk.com...
Hi Mei,
There are the steps to get the files reports from my drawing:
Menu Projects : Reports / Schematic Reports
Report Name : PLC I/O Address and Descriptions (Active drawing) - OK
(I can see all information - 38 records)
1. Save to File : CSV comma delimited - OK -> PLC.csv
(I can see all information - 38 records)
2. Save to File : Excel spreadsheet - OK -> PLC.xls
(I can see only 30 records, there are inputs missing :X02, X03, X04, X06, X1
0, X11, X12, X20, X21)
See the files attached: PLC.dwg, PLC.csv, PLC.xls
Thanks,
Kris
Message 5 of 5

Hi Mei,
I have installed SP1 and this resolved my problem with the schematics rapports in Excel and Access. Everything works fine.
Thanks,
Kris

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost