Adding to a macro to move data

[CHaythorne]

Hola,

As a bit of background, I work in Supply Chain and I'm editing a database that's an ex-employee's invention.

I have a file thats imported in the database using a macro. The way I see the macro is that it does the following;

• Imports the new file into a temp file
• Deletes the current table
• Appends the temp file to the table
• Updates a last modified timestamp

Occasionally there's data in one of the columns that needs moving into the column that's left of it.

How would I do this and where would I insert it into the Macro?

Many thanks.

Chris