Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    16

    Unanswered: Copy table from a.txt

    Hi,

    I have a.txt file which has data specified in single qoutes. For example:

    1, 'user_name', 'user_password', 'user_address', 0,1

    now when i load this file in a table (say table a), the table a has values with single quotes. When I do select * form a, it shows:

    1, 'user_name', 'user_password', 'user_address', 0,1

    How can i import without single quotes? I have around 350 files with the similar (single quote) format which need to be loaded into a DB.

    Help needed.

    Thanks

  2. #2
    Join Date
    Apr 2014
    Posts
    16

    Copy table from a.txt

    I think I got it.. Thanks

  3. #3
    Join Date
    May 2014
    Posts
    20
    can you post the solution for other knowledge.

Posting Permissions

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