Darrell Burns
dhb at flsi.com
Fri Jun 24 10:42:05 CDT 2011
Duly noted! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Thursday, June 23, 2011 1:20 PM To: Access Developers discussion and problem solving Subject: Re: [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. > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com