This one is strange

[Lori]

Okay, here goes. Every month I get an excel spreadsheet with billing data for
our cellphones. I've imported one of the spreadsheets which shows all of the
columns in the spreadsheet. Access assigned the appropriate data type and my
query and report work perfectly.

Now here's the issue: Every month I get a new spreadsheet that I want to
copy and paste into the table created by the import, however when I try I get
a error message stating that the value enters isn't valid for the field,
naturally it doesn't tell me which field but how do I get around this?

HELP!

 

[Lori]

Okay so would it be possible to set up a macro to create the table each
month? If I was dealing with the data every month it wouldn't be an issue but
I'm trying to put this together for someone with no Access experience at all.
I'm trying to idiot proof the process.