Yes although your options are limited by the versions of Excel supported. Lookup APPEND FROM in the manual. You may find it easier to save from Excel as CSV and import that.
I've written a system for this using the Royal Mail PAF files. If you're going to be storing the PAF data locally then you'll need to cater for around 15-20 lookup tables because there is so much data.
This sequence seems to do what you want.
lcTest="FA007074000"
? lcTest && FA00707400
lcTest=IIF(LEFT(lcTest,2)="FA",SUBSTR(lcTest,3),lcTest)
? lcTest && 00707400
lcTest=LTRIM(lcTest,1,"0","")
? lcTest && 707400
G.
Yes, the customer for whom I'm developing the software has purchased a license for the PAF file. There is also a set of sample files (much smaller) that are freely available to download.
Any, thanks for all the replies and the interesting background. The software is finished and on-site...
Ah, that probably explains it, then, Chris. The PAF.CSV file is roughly 2.5gb in size.
Thanks. I guess I'm going to have to split the CSV file and import each file sequentially.
Edit: I found a utility called Huge CSV Splitter that appears to have done the job.
Regards
Gary
Large CSV files is a topic that has cropped up before, I know, but I can't find a reference to this particular problem.
I'm writing a tool import address data from the UK PAF.CSV postcodes/addresses file. This is a CSV file containing (at present) 31,827,747 individual UK postal addresses. I'm...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.