472,333 Members | 1,058 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,333 software developers and data experts.

simple translation to Excel?

I am using a specialized database software (for bibliography: EndNote)
that does export in XML.

I would like to be able to read that into a simple software, like
Excel or Access, in order to do manipulation of the data (that are not
allowed in EndNote).

Anyone knows a simple tool (utility) that would allow that. By the
way, I'm using Office 2002 (not XP/2003, which may have native XML


Jul 20 '05 #1
3 4300
Excel will do it ...

Do you know how to write VBA?
Jul 20 '05 #2
> I would like to be able to read that into a simple software, like
Excel or Access, in order to do manipulation of the data (that are not
allowed in EndNote).

Unfortunately, I am not aware of a simple utility or tool that will
do what you are asking. There are a number of options available, however,
depending on how much programming you are able to do.

Option: convert EndNote XML into CSV
Since Excel can read CSV files, you are not required to convert
EndNote XML into MSFT XML in order to work with your data in a
spreadsheet. Moreover, you are likely to have better luck finding
a tool, or a programmer who can convert XML into CSV, since CSV
is not (AFAIK) a 'proprietary' format (whereas MSFT XML is).

Option: open your EndNote XML in an XML editor and do your work there

Option: Write a program or script in any language that can convert
You can write a program or a script that can read the EndNote
XML and convert it into MSFT XML Spreadsheet format yourself.
Although it is not a simple point-and-click solution, you can do
it if you know three things:
1) The specific version of EndNote XML you are working with
2) How to produce MSFT "Spreadsheet XML" for office 2002
3) How to write a script that converts part 1) into part 2)

If you Do a search on msdn.microsoft.com for:
"XML Spreadsheet (XMLSS) schema"
you will find the reference that enumerates how to generate XMLSS
files that will open in MSFT Excel.

This option is obviously the most complicated, especially if
you are not able to write a program that does this. Any language
capable of reading and writing XML should work.

I took a glance at some EndNote XML on the web, and it looks like
you will have to also decide *what part* of the EndNote XML you will
want to work with, since the whole EndNote XML file will probably not
translate easily into a single spreadsheet. (eg do you want to work
with the 'authors' section or something else?)
Jul 20 '05 #3
gi*******************@yahoo.com (GIMME) wrote in message news:<3f**************************@posting.google. com>...
Excel will do it ...

Do you know how to write VBA?

Nope. I was hoping there would be a tool to visualize an XML file
which represent a database, and there be able to interpret the schema
flexibly enough to be able to reuse it in other table/DB manager,
*without* having to program!

Let me know how "engaged" your VBA aproach would be...


Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Mick Hardy | last post by:
Hi, Has anyone seen this weird behaviour or have any suggestions or can anyone reproduce it? The history: I converted a large third party...
by: Felix Kater | last post by:
Hi, is it true that I can't define two functions with the same name even if I put them into two different c-files? Inside each file I wanted...
by: Eric Johannsen | last post by:
Hi, Is there any open source / demo code that shows how to create a simple Excel 97 or later file without resorting to Interop? My application...
by: Wayne | last post by:
I need to make a simple grid in which the user can cut and paste the contents of a region of cells from this simple grid to excel. I thought...
by: Robin Tucker | last post by:
I notice that although the .NET scheme for creating multi-language applications is generally very good (from the programmers point of view), it...
by: jacob navia | last post by:
Hi guys I have written this small parser to print out the functions defined in a C file. This is an example of parsing in C, that I want to add...
by: chelisek | last post by:
I have two simple questions: I am trying to create a document using an excel spreadsheet format. I am trying to create a column that will contain...
by: Joah Senegal | last post by:
Hello all, I;m a beginner C++ and I;m trying to convert some pseudocode into C++. Its pseudo code of the peterson algorithm for N-processes. I...
by: SamJohn | last post by:
Hello, I want to translate text dynamically from my VBA application with the Google translation tool. I have already figured out how to send the...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.