[AccessD] Automating Excel imports

I give spreadsheets to clients for data entry, but I protect
everything that I don't want them to mess up.  That said, it
generally takes me several iterations before they stop finding ways to
break it anyway. 

	Regards,  

	Steve Goodhall, MSCS, PMP 
248-505-5204

----- Original Message -----
 From:Access Developers discussion and problem solving 
To:"Access Developers discussion and problem solving" 
Cc:
Sent:Fri, 24 Jun 2011 08:42:05 -0700
Subject:Re: [AccessD] Automating Excel imports

Duly noted!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [1]
[mailto:accessd-bounces at databaseadvisors.com [2]] 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 [3]
http://databaseadvisors.com/mailman/listinfo/accessd [4]
Website: http://www.databaseadvisors.com [5]

-- 
AccessD mailing list
AccessD at databaseadvisors.com [6]
http://databaseadvisors.com/mailman/listinfo/accessd [7]
Website: http://www.databaseadvisors.com [8]


Links:
------
[1] mailto:accessd-bounces at databaseadvisors.com
[2] mailto:accessd-bounces at databaseadvisors.com
[3] mailto:AccessD at databaseadvisors.com
[4] http://databaseadvisors.com/mailman/listinfo/accessd
[5] http://www.databaseadvisors.com/
[6] mailto:AccessD at databaseadvisors.com
[7] http://databaseadvisors.com/mailman/listinfo/accessd
[8] http://www.databaseadvisors.com/