Strange Field Names

[Bill]

Hi,

I tried to import dbf file into MS Access and it looked good. I notice that
the problem screw up my queries setting. I notice that the field name has
few spaces (blank = xxxx). See example:

example:
[LastNamexxxx] - After I imported dbf file

It should be [LastName]

How I get rid of the spaces from all the fields. I have about 156 Field
Names in the table.

Your help would be much appecreated.
Thanks

 

[Jeff Boyce]

Bill

While it would be possible to come up with an automated way to revise all
those field names in the table definition, it would also probably take
longer to set up and test and run than to just edit the field names in
design mode.

However, you may have a more serious issue. If you have a table with over
150 fields, there's a very good chance that you have a spreadsheet, not a
relational database design.

If you want to get the full benefits of Access' features and functions, you
may need to normalize that table.

Regards

Jeff Boyce
<Office/Access MVP>

 

[parkjv1]

Hi,

I actually experienced this, as it turns out my table was corrupt. I
would suggest deleting and starting over.

John

 

[parkjv1]

Hi,

I actually experienced this, as it turns out my table was corrupt. I
would suggest deleting and starting over.

John