Problems with change datatypes

Results 1 to 2 of 2

Thread: Problems with change datatypes

  1. #1
    Join Date
    Dec 1969

    Default Problems with change datatypes

    I have a table in Access with 800,000 records and I need to change the dataypes of 4 fields within the table-- All records which have to change are in the correct format but stored as text--The problem is I dont have enough memory to just change the datatypes with the table design... i was thinking of creating another table with the correct datatypes and exporting parts of the old table at a time but Access does not easily allow this... Update only updates not insert... Any ideas???

  2. #2
    Join Date
    Dec 1969

    Default HUH? If you use ...

    ...multiple tables, why would you then use UPDATE???<BR><BR>You&#039;d just INSERT the old table fields into the new table and convert the types on the fly.<BR><BR>

Posting Permissions

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