Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Location
    Viet Nam
    Posts
    1

    Talking Unanswered: convert data. please help me.

    i must convert data from a table in acess to another table in acess too and new table's structure different from old table.
    old table has ten thousand records so i cannt conver it by hand. i want write a query but i'm not fluent query in acess so much.
    please help me. thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: convert data. please help me.

    Originally posted by thuhoai
    i must convert data from a table in acess to another table in acess too and new table's structure different from old table.
    old table has ten thousand records so i cannt conver it by hand. i want write a query but i'm not fluent query in acess so much.
    please help me. thanks.
    dear thuhoai,

    am in Vietnam too (HCMC) you said you wanna ('convert') copy all data from one table to another with different structure, dont you? can you list all fields of both 2 tables with their data types and most important, which field of old table will be copy to which field of new table. we may come up with a query based on that.

    cheers,
    qha_vn

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032

    Re: convert data. please help me.

    Originally posted by thuhoai
    i must convert data from a table in acess to another table in acess too and new table's structure different from old table.
    old table has ten thousand records so i cannt conver it by hand. i want write a query but i'm not fluent query in acess so much.
    please help me. thanks.
    Perhaps go to the Queries area and then click on New | Design View to start a new query.

    Then choose the old table.

    The do Query | Append Query and choose the new table name.

    Then choose which fields to use...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  4. #4
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: convert data. please help me.

    Originally posted by Bullschmidt
    Perhaps go to the Queries area and then click on New | Design View to start a new query.

    Then choose the old table.

    The do Query | Append Query and choose the new table name.

    Then choose which fields to use...
    Hello Bullschmidt, its the simplest way. Great!

    thanks
    qha_vn

  5. #5
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032

    Re: convert data. please help me.

    Originally posted by qha_vn
    Hello Bullschmidt, its the simplest way. Great!
    thanks
    You're welcome and hope you get it to work just right...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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