Search results

  1. J

    Question Export to Excel truncates data at just under 4k characters

    I have a Long Text field called EbayDescription which can contain up to around 30k characters of html (always under 32k) When I try to export using External Data > Export to external spreadsheet this field get truncated to just under 4k characters. It isn't an exact number as record 1 gets...
  2. J

    How Do You Search The Forum?

    Can someone tell me how to successfully search this forum? I've tried searches both with and without quotes and each time get 500 results, and to quote U2, "I still can't find what I'm looking for"
  3. J

    External table is not in the expected format

    I've been working on this for the last 5 hours without success, so perhaps someone here can help. I have an Excel spreadsheet linked as an external table, but when I try to use an update query I get the error "External table is not in the expected format", but only on certain records. The...
  4. J

    Can I Extraxt Data from a Field without using VBA

    I have a field called Size. The data in it looks like: 8.9 x 12.7 cm 14.1 x 20.4 cm 22.7 x 30.5 cm I have two new fields called Width and Height. They will hold numerical data only. Is there a way using an update querie to extract just the numerical data for each dimension to populate the...
  5. J

    Old Dog Learning New Tricks

    I was originally going to start this post by saying that I loved my first database. It wasn't Access but something else on an Apple Mac back in the 1980s, but now I can't even remember what it was called! Anyway, back at the turn of the millennium, I was forced to switch to PCs, and in doing so...
Back
Top Bottom