[AccessD] Wrong field type when linking to Excel

Mark,

Something I noticed that if a spreadsheet had the little green error indicator on a cell(number as text)...Access would 'choke' on it but not real sure how to fix it other than clear the error in excel.  I'm sure there is a way...I just haven't researched it.


> Date: Thu, 17 Jul 2008 11:29:57 -0800
> From: Mark.Porter at nana.com
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Wrong field type when linking to Excel
>
> 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

_________________________________________________________________
Use video conversation to talk face-to-face with Windows Live Messenger.
http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_072008