ImportMixedTypes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RhysPieces - 26 Feb 2007 19:23 GMT

Like many, I am experiencing difficulting making all the right settings so my
linked Excel table will correctly import a column (type=Text) of values
containing text, numbers, or a mix of the two to an Access report. Have read
the 'dicks-blog' article and made the first two changes
(ImportMixedTypes=Text & TypeGuessRows=0). Can't figure out where to access
the section about checking if IMEX=1 setting is correct. Don't normally get
into that stuff. Please provide directions. Any further ideas to help
importing are appreciated as well. This is a daily report and I am tired of
making entries by hand.

Reply to this Message

Jamie Collins - 27 Feb 2007 15:14 GMT

On Feb 26, 7:23 pm, RhysPieces <RhysPie...@discussions.microsoft.com>
wrote:

> Like many, I am experiencing difficulting making all the right settings so my
> linked Excel table will correctly import a column (type=Text) of values
[quoted text clipped - 5 lines]
> importing are appreciated as well. This is a daily report and I am tired of
> making entries by hand.

Here's one way:

http://support.microsoft.com/kb/240222

You want to do something like this:

adoTbl.Properties("Jet OLEDB:Link Provider String") = "EXCEL
8.0;HDR=YES;IMEX=1"

Jamie.

--

Reply to this Message