I work in a school and the database we have exports the following into an excel file automatically.
Firstname text
Lastname text
Year (as year 8) text
Group text
I'd like to import it into a table using vba using docmd but the table set up is:
Firstname text
Lastname text
Year (as 8) integer
Group text
Can anyone advise how to get the data in the right format into the table. I'd like the whole process to be by vba.
Many thanks
Andy
Sent from my iPhone using Tapatalk