[AccessD] Wrong field type when linking to Excel

Sometimes I put a dummy first data row in an Excel file to get it to
import the way I want. Put in something like XXXXX if you want it to
be taken as a text field rather than a numeric.

GK

On 7/17/08, Mark Porter <Mark.Porter at nana.com> wrote:
> I'm linking to an Excel sheet and getting an incorrect field type
> (numeric instead of text).
>
>
>
> I get the same problem when importing the sheet into a table with the
> field specified as text.
>
>
>
> I have not had this issue with Excel sheets with similar data, so I'm
> tempted to look for something wrong with the sheet (the field is set to
> Text).
>
>
>
> Saving as CSV and importing that way causes other issues.
>
>
>
> Any ideas or solutions?
>
>
>
> Thanks in advance,
>
>
>
> Mark Porter
>
> Sr. Technologist
>
> Nana Development Corp.
>
> Desk: 907-265-4156
>
> Fax: 907-343-5656
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com