General information
Category:
COM/DCOM and OLE Automation
Thanks for the reply Hilmar,
While preformatting the columns as text and using the clipboard to paste the data into Excel fixes the problem where some data was converted into dates and numbers, it still has all the trailing spaces. This means I still must include an extra step to strip the spaces back out.
Also even 2 Ghz PCs with 1GB of Ram can get choked putting 6-10 million values in the clipboard. Therefore, I am drifting away from solutions that involve loading all of the data into the clipboard at the same time.
Anyway, I keep coming back to the conclusion that using a .CSV file is still my best solution since I am dealing with large amounts of data. Also, I should point out that the problem data will only potientially occur in a couple of columns.
My current approach is to make a .CSV file that looks like:
="problem column", "etc..."
="0123", "etc..."
="12-1", "etc..."
="7440-09-7", "etc..."
When Excel opens the .CSV file, it sees the extra "=" prefix character so it evaluates the expression and displays the data as text. Granted, if you click on the cell, you see things like ="0123" which might be annoying to some, but I could always copy the column and repaste it back in as values if necessary.
I am still interested however if anyone has other solutions that I have overlooked.
Thanks,
Jeff
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only