Re: Change field names to first row of table
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Fri, 23 Mar 2007 03:34:16 GMT
"Bob" <scrawford@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
I've got a table that I've imported and it has
junk at the top of the table, so after import
I run a delete query to remove the junk lines
then I'm left with the field names I want for
the table at the top of the table but the field
names currently are 'field1' etc, so how do I
rename the field names to the fields on the
top row of the table.
If the column names were all in the first row, you could specify that in the
Import Wizard, and not have to do any post-processing. It is a little
unusual for the Column Headings to be split over two rows, but you could
write VBA code to do what you want, after you have imported the information
into a table; or, perhaps, depending on the format of the data that is being
imported, before or as you import it.
Larry Linson
Microsoft Access MVP
.
- Follow-Ups:
- Re: Change field names to first row of table
- From: Gord
- Re: Change field names to first row of table
- References:
- Change field names to first row of table
- From: Bob
- Change field names to first row of table
- Prev by Date: Re: Database only works for a week
- Next by Date: Re: Formatting File Names for OutputTo
- Previous by thread: Re: Change field names to first row of table
- Next by thread: Re: Change field names to first row of table
- Index(es):
Relevant Pages
|
