Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2015
    Posts
    7

    Unanswered: Query - All column on text format

    Hello.

    I have a table and I import it automatically. But now, I want to keep this import automatically but all columns as text. Because I'm facing some problems cuz' some fields come with ".", "/" and "-".

    How can I do it?

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    reset the target table and make all fields = text.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use the appropriate datatype for the the data.
    if the data is coming in garbled then filter it / pre process it BEFORE import OR import into temporary tables then move what you can into the main system as it gets sanitised / verified.

    dont compromise system / data integrity because someone else is shovelling SH!t into your system
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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