Converting table from Works to Access

[rr02bo2]

Hello,

We have currently been working with a Microsoft Works (v.4.5a) database, however we have now reached the 32000 record limit. I would like to convert the table to Access (Access 2000) to allow better flexibility and to increase our capacity. I have had some success in doing so: I have saved the works file as a dBASE IV file, and have been able to open it in Access. I thought that everything was great but have now realized that the last few fields of the table did not import. Our current database has about 45 fields. I don't know if the problem occurs when saving as a dBASE IV file - is there a limit to the size and/or # of fields? (I had to increase the field width of every field to ensure that the text was not truncated), or is it a limitation within Acess?

Any insight/suggestions would be appreciated.

Thanks!

[ChipR]

I found this description of the dBase IV format. You may be able to use a hex editor and open the dBase file to verify that it exported successfully with all your fields.

[NeoPa]

Welcome to Bytes!

Unless your database is very complicated, I would consider defining the record structure and other configurations in Access manually. That way you can make sure everything is done correctly, and get at least a basic understanding of what is available in your new application (Access).

That way too, you can export and import the data via various formats of your choice. Text is often a good one and allows you a pretty good view of exactly what is being produced. Be careful though of any embedded data which duplicates any of your special characters (EG commas (,) in some fields if you use commas to separate fields).