[AccessD] Import errors from Excel

I've been bitten there too.  I had a spreadsheet of lab reports for oil palm leaf analysis.
One of the columns had names such as "Sep 2" and "Sep 4".   The import very kindly 
converted these to dates :-(

-- 
Stuart

On 7 Dec 2009 at 14:18, jwcolby wrote:

> Problem #3; If the data in the column begins with characters, then all is good, when imported into 
> excel, the data will be brought in as data type text.  Otherwise... the column will be set to an 
> integer (and lose the leading zeros).
>