Smithsonian National Museum of Natural History logo

Osteoware: Standardized Skeletal Documentation Software

Osteoware: Standardized Skeletal Documentation Software

exporting data into Excel spreadsheets cuts off summary section

2 posts / 0 new
Last post
Offline
Last seen: 5 years 1 month ago
Joined: 03/07/2012 - 13:48

When I try to export a table (e.g. Age/Sex) from Advantage Data Architect to Excel, a hidden character limit cuts off whatever is contained in the summary/notes section of Osteoware for this module.  Can this be avoided/corrected?  The comments section helps when interpreting the summary age and sex columns exported with it.

 

Thanks,

 

Stuart

C Dudar's picture
Offline
Last seen: 1 week 4 days ago
Joined: 12/09/2011 - 13:44

Yes, I know the Excel limitation to the text field (!) it is a Microsoft problem.  I suggest that if you need any Osteoware text field that you export into Word rather than Excel. 

Advantage exports the complete text string into a Word Table format, and you simply adjust column widths to suit a report format.  Use Excel to sort and analyze your numerical data, and to export to stats programs.

I hope this workaround resolves your issue.

Edit: look into the link provided by Martin Bond below (thank you Martin), although it discusses the issue as it pertains to Excel and Access databases, while Osteoware uses Advantage Data Architect.  However, same problem, Excel limits import to 255 characters...