Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2004
    Location
    Fort Collins, Colorado, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word Spacing (ACC 2000+)

    I have a client, importing Excel surveys.. pretty standard, with four text columns in the Excel .. Access VBA modules read and import from code, and it's fine. Small problem, the text fields which contain questions or answers are all 'run-on' .. ie the spaces have been carved out and I'm left with a single continuous string in the Access table .. The Access table schema is set to expect text 255 or memo fields, so I'm sorta confused. Can you help me ?? Regards Wayne

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sydney, Australia, New South Wales, Australia
    Posts
    251
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Word Spacing (ACC 2000+)

    How are you bringing the text in? You mention VBA code; do you want to post the code that's doing the import?
    Peter

  3. #3
    Lounger
    Join Date
    Dec 2004
    Location
    Fort Collins, Colorado, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Spacing (ACC 2000+)

    Peter, it's just a "DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, szTarget, szPath, True, szRange" ... comes in normally to a "cache table", drfined as text columns or a Memo field (these people write paragraphs where two sentences would work fine). But, occasionally, it goes nuts, and jambs all the words together, .. than at other times it uses nomal spacing. I can't put my finger on the trigger that's causing the problem. Many Excel files, all the same Template, just different text in the cells. Regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word Spacing (ACC 2000+)

    I cannot think of any situation in which DoCmd.TransferSpreadsheet would remove spaces from text values. Is there any chance you could post one of the "problem" workbooks?

  5. #5
    Lounger
    Join Date
    Dec 2004
    Location
    Fort Collins, Colorado, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Spacing (ACC 2000+)

    Hans, I found the problem .. parsed by another procedure call .. My error in not seeing it earlier ... nested in a mess of code. Thanks to both of you ... Wayne ps I did learn something, though "a text field definition in MS Access, is treated a little different than a Memo field ... that is, when importing Excel"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •