If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Strange Field Names
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 |
#2
|
|||
|
|||
Strange Field Names
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 "Bill" wrote in message ... 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 |
#3
|
|||
|
|||
Strange Field Names
Hi,
I actually experienced this, as it turns out my table was corrupt. I would suggest deleting and starting over. John |
#4
|
|||
|
|||
Strange Field Names
Hi,
I actually experienced this, as it turns out my table was corrupt. I would suggest deleting and starting over. John |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Field Names | Parts Manager | Database Design | 5 | April 20th, 2005 06:42 AM |
Don't want to display Field Names in Medium Style Booklet | TTeam | Contacts | 1 | August 17th, 2004 09:58 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |
Create table with field names based on the value of a field in another table. | [email protected] | Database Design | 5 | May 24th, 2004 02:32 PM |