[AccessD] Automating Excel imports

Finally,  you've identified the real problem.

Don't give clients spreadsheets for data entry.  They *will* screw them up.
Give them a some other tool such as a simple Access database with a single continuous 
form bound to a single table.

-- 
Stuart


On 23 Jun 2011 at 7:48, Darrell Burns wrote:

> That's the problem...not all of the columns are formatted as text. I
> created the template that way, but sometimes the client does a paste
> and changes the format.
>