S
SCBClaus
I'm making this database for other users.
They just have to import an Excel file in to the Access and it has to print
a report. By clicking a button, this will run a macro to run a query on the
table and change amounts and filter records. Then has to link another table
to get a specific card number for the matching name. But the column of the
imported file is text and it has to be linked or match a column with data
type number. How can I also automate the Datatype of the table from text to
number (long integer)?
Please help...
They just have to import an Excel file in to the Access and it has to print
a report. By clicking a button, this will run a macro to run a query on the
table and change amounts and filter records. Then has to link another table
to get a specific card number for the matching name. But the column of the
imported file is text and it has to be linked or match a column with data
type number. How can I also automate the Datatype of the table from text to
number (long integer)?
Please help...