HomeMicrosoft


MS Streets & Trips unable to open a large MS Excel file at import
gtang
At my work we are currently using Streets & Trips 2008 to map out our facility coverage. The problem I'm having is that the Excel spreadsheet we are using is HUGE. As in the number of columns is somewhere in the 100's and the number of individual entries in each column are in the 1000's. When I try to import the data into the program, I just get an error message saying that it can't open the file.

Is there any fix to this without having to re-format the source spreadsheet by reducing the number of columns?
Larry
Hi gtang

Welcome to the forum. I'm sure we can get this to work for you. Have you tried to zero in on the problem by using the divide and conquer approach. (ie split the data into 2 files and see if they both fail or one passes)?

I'd be willing to look at the xls file for you if you want to email it to me at streetsandtrips[at]hotmail[dot]com.
gtang
I've already experimented with reducing the number of columns to include just the relevant columns (which decreases it significantly). The problem is that our President doesn't want us to create a seperate source file. Ideally, he wants this one spreadsheet to be the source for a number of different applications, and he doesn't want random copies of that file sitting in various locations around our server.

I'm not sure if that made any sense...
Ken in Regina
Quote:
Originally Posted by gtang
I've already experimented with reducing the number of columns to include just the relevant columns (which decreases it significantly). The problem is that our President doesn't want us to create a seperate source file. Ideally, he wants this one spreadsheet to be the source for a number of different applications, and he doesn't want random copies of that file sitting in various locations around our server.

I'm not sure if that made any sense...
Yes. Both your explanation and your President's reasoning are crystal clear.

...ken...
malaki86
You might want to check out GPSBabel. It has the ability to convert one file format to another, without affecting the original file.

Just do a Google on it.
Ken in Regina
In addition to GPSBabel there is also ITNConverter. You will have to save the Excel file as a .CSV file for input to both of them. I'm not sure if they are smart enough to pick the proper columns from the top row names, in which case you'll have to make sure you use the right names, or if the columns will have to be in a specific order for them to find the necessary data for the conversion.

...ken...
gtang
I tried converting it to CSV, but I still get a message when I try to import the date saying it can't open the CSV file.
Larry
Gtang - S&T should not be choking on this file. It can open large xls files just fine. It might be something "in" the file that is problematic. My suggestion to divide it into smaller chunks was not as a permanent solution but only as a temporary way to better diagnose the problem. Once we figure out why it is choking we can fix it and then use the full complete file with the fix.
gtang
There's a lot of formulas in the spreadsheet that are irrelevant to the location, and when I delete those, S&T doesn't have a problem.
laptopgpsworld.com About