AS400 Linked to Access

[Guest]

I am using Access as for my Asset Tracking and Rental Management Application.
I have a table linked to AS400 to pull updated customer information. My IT
Dept doesn't want to risk my team changing anything. So I have to use
Make-Table to create my own Customer Table. When I need to update the data
every week, I run Delete Query to delete records from MY TABLE; then run Make
Table Query to pull AS400 Info. But before I can run APPEND Query I have to
change the data type of the Customer ID field from "TEXT" to "NUMBER".

Is there an easier way? I would like to set a macro, query, or VBA code
that will update my customer table with a click of a button.

 

[Brendan Reynolds]

Your append query can handle the conversion from text to number for you ...

INSERT INTO Customers ( CustomerID )
SELECT Val([CustomerID]) AS Expr1
FROM ImportedCustomers;