Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Posts
    1

    Unanswered: How to Migrate the .xls file into tables.

    Hi,

    can anyone help me how to migrate the .xls file into another table, where there data type fields are different.

    i tried through DTS but iam getting some errors.

    Please help me out.

    if possible please write the query for that.

    ----
    actually what i have done is i migrated the xls to a new table in the same database which i have to migrate this one to another table..

    after migrating the new table i tried to migrate the source to destination table but iam getting some errors like data fields are not matched..

    Actually iam new for this SQL queries so please help me out plzzzzzzzz
    Last edited by sql_chinny; 08-03-07 at 07:15. Reason: reply's form members

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Slap the XLS file into a table of the same format as the file and then start fiddling with the data..?
    Quote Originally Posted by sql_chinny
    if possible please write the query for that.
    No that is not possible, members are here to help, not do your job for you!
    George
    Home | Blog

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    slap == LOAD DATA INFILE

    it's in the manual
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I was deliberately being vague




    ...honest
    George
    Home | Blog

Posting Permissions

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