EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » EVE-Central URL too long for Excel (and maybe other gen...

Topic is locked indefinitely.

EVE-Central URL too long for Excel (and maybe other general advice)
Author

Previous Topic Next Topic

Nacho Girl

Garoun Investment Bank

Gallente Federation

Likes received: 0

#1 - 2013-01-20 00:20:25 UTC | Edited by: Nacho Girl

I've hit a wall. My EVE-Central query is too long to paste into Excel XML import.

I'm very savvy with Excel/Access/SQL but not VBA/XML. What the heck can I do to get this data linked to Excel OR Access without opening the VB can of worms?

As it stands I have:

1a) An Excel workbook with all XML imports as separate sheets.
1b) An ODBC source to the data dump.

2) An Access db linked to the workbook and data dump.

3) SQL views joining/aggregating everything and running (some) calculations.

4) A final, cosmetically appealing Excel "interface" workbook linked to (and running formulas on) the aggregate views.

Works brilliantly so far. Sat down to day to incorporate EVE-Central data and wham.... no way to get it into workbook 1.

Wat do?

edit: I *could* break my imports up into <255 char URLs and union them in Access, but thats.... stupid.


Nacho Girl Garoun Investment Bank Gallente Federation Likes received: 0	#2 - 2013-01-20 00:43:08 UTC Surprisingly (to me, the XML noob), goog.gl shortened URLs work just fine for this...! Problem solved, thanks Ahzrael!