Cannot update large table in Access 2003

[Cordeiro82]

Hello All,

I imported several shipment text files into a single Access table in order to query them for a distribution analysis that I am doing.

The table has about one year of shipment data and has 16 fields and over 788,000 records.

All the fields imported as text and when I try to change any of them to an alternate data type (eg: change the Qty field to a number or the GI date field to a date/time type) it times out with the following message:

Microsoft Office Access can't change the data type: There isn't enough disk space or memory.

I am running on a computer with 512MB DDR SDRAM, a P4 2.4Ghz processor, and 150GB of disk space with 120GB free.

Could anyone tell me how to speed up the database and update the records without having it grind to a halt.

Thanks,

Kevin

 

[PHV]

You may try to import the text files one at the time in a temporary table you base an append query with proper formatting on.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886