Trying to run a query on a csv file (* delimeter)
(Because its bigger than 3M), so can't import the lot!
problem no.1 - the jet engine doesn't work with 64 bit Office.
problem no.2 ODBC - don' want every machine to set up ODBC connection; dsn-less connection - driver manager error
anyone got 'here's one I made earlier' that will run with 64 bit Excel??
TIA
Hi,
did you try opening (not importing) the csv file with excel setting the format parameter to csv?
http://msdn.microsoft.com/en-us/libr.../ff194819.aspx
Regards
Please Login or Register to view this content.
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please clickto give reputation
Read the FORUM RULES
Thought of that; however because the file is bigger than excel can handle, I need to run a quey to return a sub-set of the data before loading/opening the file.
Also - once opened, using a for .. next loop to enter the result into excel will be slow?
So I suppose it's 3 GigaByte here.. shouldn't 64bit Excel open this? Might take some time thoughOriginally Posted by oldfart101
Once opened you parse all data into an array with one codeline, construct your output in another array and paste it with one codeline, that's faster than looping through all cells.
Regards
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks