Find/replace/combine data

[Tcurtis]

I am new to Access and want to covert my database over from Excel where I am very confortable to Access. I have a problem with several fields in my tables though. I need to search one column of data and replace it with the correct data. Example: Column Depot has several misspellings that I need to replace with Houston. How do I replace all those misspellings to the correct spelling? Also, since I have three tables that are exactly the same except the are from different Depots, how to I make them all into one table?
I am looking for the most effecient way to do this instead of running all my data through Excel and them importing it into Access. Do I import and append my data into one table and then correct the three depot spellings or correct them indepently and then combine?
Thanks

 

[alansidman]

For the misspellings, you could import the table and then run an update query to correct them and it really doesn't make much difference whether you do them individually or combined.

To put the three tables into one table in Access, you have two options. Import the first one and then append the next two as they are imported or my lease favorite idea is to Import each one individually, run a UNION query and then a select query using the Union as a recordset and finally creating a new table with a Make Table query. A bit of an exercise, but an option.

 

[Tcurtis]

Thanks Alan, I think my best option would be to import one table and then append the other two to that one and do an update query. Since this is a monthly report, I could just append the new tables and run the update query which sounds much better in the long run. Access has so many options I had too many options to choose from. Thank you for your input, it is much appreciated.