Recent content by Blueskies

  1. B

    Solved Problems exporting text file

    Thanks! - I can sleep tonight now. And many thanks for looking at this with me. I think I might have given up earlier without someone to communicate with!
  2. B

    Solved Problems exporting text file

    OK I've finally got to the bottom of this I think - there are some additional characters at the start of the file. I opened it up in hexed.it which is a very useful online hex editor and found this: My previous check didn't pick up these characters to the left of 'PAF_URN' Access accepted...
  3. B

    Solved Problems exporting text file

    I just transferred the text file via Dropbox instead of email and this time it opened the same on the other PC. I imported into Access 2013 and then tried exporting again as text. I still got the error message. I tried re-creating the text file by copying and pasting the text into a new text...
  4. B

    Solved Problems exporting text file

    This has to be one of those (thankfully rare) situations where the error message doesn't bear any relation to the actual problem. Makes finding out what's actually going on all the more fun.
  5. B

    Solved Problems exporting text file

    This is really odd now. Here's the test file I've been importing into Access 2016: PAF_URN,Town,Postcode,Latitude,Longitude,Coordinate_Level 9941,ABERDEEN,AB10 7HJ,57.12534,-2.121958,Address 9942,ABERDEEN,AB10 7HJ,57.12569,-2.121909,Address 9943,ABERDEEN,AB10 7HJ,57.1257,-2.121728,Address...
  6. B

    Solved Problems exporting text file

    Weird - so we know: 1. It's a specific field that's the problem 2. This field is Long Integer type, but has no unusual field attribute settings 3. Changing the name of the field or using an alias in a query can make a difference between getting an export error or not 4. It's nothing to do with...
  7. B

    Solved Problems exporting text file

    Well, I just had a look at ASCII values of the characters in the field name line in case there was some hidden character causing an issue (I've seen this before with xml files) I found all the characters are in the usual ASCII range - all between decimal 44 and 122, which covers 'normal'...
  8. B

    Solved Problems exporting text file

    Hi Thanks for looking at it. The table would have been created from a text file. I've changed the field names now, but attached is the one I used, with a few records in it. I did find it exported to Excel myself, so something to do with a text export specifically. Odd that you managed to get...
  9. B

    Solved Problems exporting text file

    Hi I have a table with a Long Integer field which is causing me some difficulties. When I try to export it to a text file I get an error: The Microsoft Access database engine could not find the object 'text export#txt'. Make sure the object exists and you spell its name correctly. If 'text...
  10. B

    system resources exceeded when exporting queries

    Fascinating! Your explanation of the the error handler behavious makes sense - liking your idea of a fatal error too! As a mere 51 years old I'm afraid your description of chain-drive disks is nothing I've ever encountered, but I loved reading about it!
  11. B

    system resources exceeded when exporting queries

    Hi - thanks for the posts guys. Oddly enough I seem to have got around the problem - I put in an error handler that simply re-ran the 'export_tab_to_csv' sub when it got to a resources error. I thought this would only be the start of solving this, but the error handler only tiggered once...
  12. B

    system resources exceeded when exporting queries

    Hi I've got some code which loops through all a bunch of queries which are looking at linked tables in my database. For each query it runs this: Sub export_tab_to_csv(mytab As String) Dim qname As String Dim exportpath As String qname = "Export " & mytab exportpath =...
  13. B

    Running SQL statement from within a function called from a query

    Hi Sorry, I haven't replied for a few days. I'll try your code ASAP.
  14. B

    Running SQL statement from within a function called from a query

    Hi I just ran another test an it did 1,000,000 records in 25 minutes. I've picked a random result to test: Lat Lon RestaurantId RestaurantDistance 51.59114 -2.925567 1146 2.43659047751239 According to Google maps, this address is Playford Cres, Newport NP19 9HY. The restaurant Id...
  15. B

    Running SQL statement from within a function called from a query

    OK, I've opened the 20 million record text file and can see the details is there. I've split it into files of 5 million lines each to make it easier to import into Access (due to the header being counted as a line, the final file is 1 record!) It looks like the file is too big now to upload in...
Top Bottom