Make Table Query help

[rmorgan]

I am using a Make Table Query to filter a Linked Excel Table. Is there a way to cut/drop the first 8 characters of the text out of one of the fields as it creates the new table?

Field Name Excel Data Final Data
Model_Name LATITUDE D600 D600

Also, the final table has two Relationships with two other tables. When I run the Make Table Query once a week, I have to break the relationship to get it to run. Is there an easier way to dial with this?

 

[KeithG]

You can use the mid function to drop off the first 8 characters. As for having to break the relationship I am not sure can you post your db?

 

[pbaldy]

Rather than a make table query, delete all data from the existing table then append your new data into it.