[AccessD] Automating Excel imports

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




More information about the AccessD mailing list