Importing with no field names

L

Lin Light

I have a datafile I need to import but the fields come with no names, just
numbers.
1 - 27.
I would like a way to rename those fields numbers to names and during the
process not import certain fields.
This will be an ongoing thing and will be always going into the same database.
I suppose I could do it after the comes in as a seperate table then make the
changes and copy it into that other table.

LIn
 
J

Jeff Boyce

You don't mention the source data, but many times the data imported into
Access is not well normalized.

Consider creating queries to "parse" the import data into more permanent
Access tables you've designed to be well-normalized.

Another option would be to create a table in Access that has the fieldnames
you wish, then import the data by appending to that table.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
P

Pete D.

I would link to the excel file and append it to the table with a standard
query. As long as you replace the original excel file with the new one that
is always the same all you need to worry about is running the query.
 
L

Lin Light

Link I got. But the append it to the table with a standard query is not clear
to me.

Lin
 
J

Jeff Boyce

Step 0 - backup, backup, backup!

Step 1, link to the data.

Step 2, create an Access table that IS the way you want it to be.

Step 3, create an Access query, add the fields from the linked data, change
the query type to "Append", then select the appropriate fields from the new
Access table you created in Step 2.

Step 4, run the append query.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
P

Pete D.

Please provide me with excel column titles and what you want for field names
in access. For instance

1 = FirstName
2 = MiddleName
3 = LastName

What you would do is create a table with the field names you want. Then you
map the excel column titles (numbers) to those fields. As long as the excel
file doesn't change your map to the field names will remain the same, Then
you create an append query to take the linked excel file to each field in
Access. Send us a little more info on your excel file and desired results
and I'll provide you more details.
Pete
 
P

Pete D.

Well by the time I refreshed my newsgroup Jeff had already said it all. Any
way, if you need more help post back. Pete
 
Top