How change column names in 1 operation?

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I have a table with many fields. I need to change the fieldnames.

I have an Excel row with the fieldnames that I need. How can I easily
change the Access Table fieldnames by using the row of fieldnames from excel?

I will need to do this operation with some frequency and manually changing
each fieldname is not an option.

Alternatively, how can I move my records to a new table that has different
fieldnames?

With Regards-
Sam
 
I will need to do this operation with some frequency
Sounds like you are trying to use Access as a spreadsheet.
Excel row to Access field names -- Add row of data below field names that
correspond to datatype for the fields, i.e., Text - A, Integer - 11,
Number-Single - 11.234, Boolean - Yes.
Import Excel sheet as new table, delete the row of data, append records to
new table.
 
I seem to be missing something here... How do you append a table to another
table that has different fieldnames? That is the point of my post.
Click to expand...

An Append query lets you specify different field names for the source and the
destination. If you create a new Query based on a table in your database,
change it to an Append query using the query-type tool on the toolbar or the
Query menu operation. You'll see a new row in the grid "Append To:" in which
you can select the fieldname into which the data should be put.
 
Back
Top