Excel Returns Blank

I'm trying to import data from several Excel files into one single workbook
but having a problem with blank cells. I now understand this is due to mixed
data types.

I 've updated my registry key to Zero "TypeGuessRows" What I don't
understand is the connection string which needs the following statement
adding "IMEX=1" please can someone give me an idots guide how I go about this!

Where / how do I add the statement, is it within Excel ?

Thanks in advance.

Read through this thread:

http://tinyurl.com/dqwmj

--
Regards,
Tom Ogilvy


"Jeff" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to import data from several Excel files into one single
workbook
> but having a problem with blank cells. I now understand this is due to
mixed
> data types.
>
> I 've updated my registry key to Zero "TypeGuessRows" What I don't
> understand is the connection string which needs the following statement
> adding "IMEX=1" please can someone give me an idots guide how I go about
this!
>
> Where / how do I add the statement, is it within Excel ?
>
> Thanks in advance.
>
>
>
>

Thanks Tom for the post. I'm still at a lost to know how to add the
connection string:
Setting "IMEX=1" in the Extended Properties section of the
> connection string.

Where do I add these statements? I'm sorry but I'm a complete amateur at
this and would be grateful for an idiot guide.

Thanks

"Jeff" wrote:

> I'm trying to import data from several Excel files into one single workbook
> but having a problem with blank cells. I now understand this is due to mixed
> data types.
>
> I 've updated my registry key to Zero "TypeGuessRows" What I don't
> understand is the connection string which needs the following statement
> adding "IMEX=1" please can someone give me an idots guide how I go about this!
>
> Where / how do I add the statement, is it within Excel ?
>
> Thanks in advance.
>
>
>
>

There is sample code in the thread to which I posted a link. Perhaps you
should look at that. Otherwise, I guess I don't know what you are doing.

--
Regards,
Tom Ogilvy

"Jeff" <[email protected]> wrote in message
news:[email protected]...
> Thanks Tom for the post. I'm still at a lost to know how to add the
> connection string:
> Setting "IMEX=1" in the Extended Properties section of the
> > connection string.
>
> Where do I add these statements? I'm sorry but I'm a complete amateur at
> this and would be grateful for an idiot guide.
>
> Thanks
>
> "Jeff" wrote:
>
> > I'm trying to import data from several Excel files into one single
workbook
> > but having a problem with blank cells. I now understand this is due to
mixed
> > data types.
> >
> > I 've updated my registry key to Zero "TypeGuessRows" What I don't
> > understand is the connection string which needs the following statement
> > adding "IMEX=1" please can someone give me an idots guide how I go about
this!
> >
> > Where / how do I add the statement, is it within Excel ?
> >
> > Thanks in advance.
> >
> >
> >
> >

Hi Tom,

Does this code get copied into the "Visual Basic Editor" area of Excel?

Thanks

Jeff



"Tom Ogilvy" wrote:

> There is sample code in the thread to which I posted a link. Perhaps you
> should look at that. Otherwise, I guess I don't know what you are doing.
>
> --
> Regards,
> Tom Ogilvy
>
> "Jeff" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks Tom for the post. I'm still at a lost to know how to add the
> > connection string:
> > Setting "IMEX=1" in the Extended Properties section of the
> > > connection string.
> >
> > Where do I add these statements? I'm sorry but I'm a complete amateur at
> > this and would be grateful for an idiot guide.
> >
> > Thanks
> >
> > "Jeff" wrote:
> >
> > > I'm trying to import data from several Excel files into one single
> workbook
> > > but having a problem with blank cells. I now understand this is due to
> mixed
> > > data types.
> > >
> > > I 've updated my registry key to Zero "TypeGuessRows" What I don't
> > > understand is the connection string which needs the following statement
> > > adding "IMEX=1" please can someone give me an idots guide how I go about
> this!
> > >
> > > Where / how do I add the statement, is it within Excel ?
> > >
> > > Thanks in advance.
> > >
> > >
> > >
> > >
>
>
>

No. It shows how to modify your existing code. If you are not using
existing code, then perhaps you need to use the macro recorder while you do
what you are doing manually, then modify the recorded code in accordance
with the extended properties portion of the code in the link.

--
Regards,
Tom Ogilvy

"Jeff" <[email protected]> wrote in message
news:[email protected]...
> Hi Tom,
>
> Does this code get copied into the "Visual Basic Editor" area of Excel?
>
> Thanks
>
> Jeff
>
>
>
> "Tom Ogilvy" wrote:
>
> > There is sample code in the thread to which I posted a link. Perhaps
you
> > should look at that. Otherwise, I guess I don't know what you are
doing.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Jeff" <[email protected]> wrote in message
> > news:[email protected]...
> > > Thanks Tom for the post. I'm still at a lost to know how to add the
> > > connection string:
> > > Setting "IMEX=1" in the Extended Properties section of the
> > > > connection string.
> > >
> > > Where do I add these statements? I'm sorry but I'm a complete amateur
at
> > > this and would be grateful for an idiot guide.
> > >
> > > Thanks
> > >
> > > "Jeff" wrote:
> > >
> > > > I'm trying to import data from several Excel files into one single
> > workbook
> > > > but having a problem with blank cells. I now understand this is due
to
> > mixed
> > > > data types.
> > > >
> > > > I 've updated my registry key to Zero "TypeGuessRows" What I don't
> > > > understand is the connection string which needs the following
statement
> > > > adding "IMEX=1" please can someone give me an idots guide how I go
about
> > this!
> > > >
> > > > Where / how do I add the statement, is it within Excel ?
> > > >
> > > > Thanks in advance.
> > > >
> > > >
> > > >
> > > >
> >
> >
> >

Perhas that answer was too quick since I don't really know what you are
doing. Perhaps invest some time reading this link and see if you can adapt
it:

http://support.microsoft.com/default...b;en-us;257819

This was in the original link as well. (there is a second link there you
might want to check as well).

--
Regards,
Tom Ogilvy

"Jeff" <[email protected]> wrote in message
news:[email protected]...
> Hi Tom,
>
> Does this code get copied into the "Visual Basic Editor" area of Excel?
>
> Thanks
>
> Jeff
>
>
>
> "Tom Ogilvy" wrote:
>
> > There is sample code in the thread to which I posted a link. Perhaps
you
> > should look at that. Otherwise, I guess I don't know what you are
doing.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Jeff" <[email protected]> wrote in message
> > news:[email protected]...
> > > Thanks Tom for the post. I'm still at a lost to know how to add the
> > > connection string:
> > > Setting "IMEX=1" in the Extended Properties section of the
> > > > connection string.
> > >
> > > Where do I add these statements? I'm sorry but I'm a complete amateur
at
> > > this and would be grateful for an idiot guide.
> > >
> > > Thanks
> > >
> > > "Jeff" wrote:
> > >
> > > > I'm trying to import data from several Excel files into one single
> > workbook
> > > > but having a problem with blank cells. I now understand this is due
to
> > mixed
> > > > data types.
> > > >
> > > > I 've updated my registry key to Zero "TypeGuessRows" What I don't
> > > > understand is the connection string which needs the following
statement
> > > > adding "IMEX=1" please can someone give me an idots guide how I go
about
> > this!
> > > >
> > > > Where / how do I add the statement, is it within Excel ?
> > > >
> > > > Thanks in advance.
> > > >
> > > >
> > > >
> > > >
> >
> >
> >

Hi Tom,

Thank you for your time and effect, much appreciated.

I think the area of programming is a step too far for me.

In your reply you said you didn't really know what I was trying to achieve,
basically it was this:

I have a master spreadsheet which imports data from several Excel
spreadsheets via the "Import External Data" option, the error I was getting
was NULL cells, which I now know is due to mixed data types.

I can follow the registry fix but have now idea how to add the connection
string (If this is the right terminology to use) due to the liminations of
the Jet Driver.

You state the code is added in the marco field but no marco's are used for
this import only the "Refresh" option.

I hope this makes sense.

Thanks





"Tom Ogilvy" wrote:

> Perhas that answer was too quick since I don't really know what you are
> doing. Perhaps invest some time reading this link and see if you can adapt
> it:
>
> http://support.microsoft.com/default...b;en-us;257819
>
> This was in the original link as well. (there is a second link there you
> might want to check as well).
>
> --
> Regards,
> Tom Ogilvy
>
> "Jeff" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Tom,
> >
> > Does this code get copied into the "Visual Basic Editor" area of Excel?
> >
> > Thanks
> >
> > Jeff
> >
> >
> >
> > "Tom Ogilvy" wrote:
> >
> > > There is sample code in the thread to which I posted a link. Perhaps
> you
> > > should look at that. Otherwise, I guess I don't know what you are
> doing.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Jeff" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Thanks Tom for the post. I'm still at a lost to know how to add the
> > > > connection string:
> > > > Setting "IMEX=1" in the Extended Properties section of the
> > > > > connection string.
> > > >
> > > > Where do I add these statements? I'm sorry but I'm a complete amateur
> at
> > > > this and would be grateful for an idiot guide.
> > > >
> > > > Thanks
> > > >
> > > > "Jeff" wrote:
> > > >
> > > > > I'm trying to import data from several Excel files into one single
> > > workbook
> > > > > but having a problem with blank cells. I now understand this is due
> to
> > > mixed
> > > > > data types.
> > > > >
> > > > > I 've updated my registry key to Zero "TypeGuessRows" What I don't
> > > > > understand is the connection string which needs the following
> statement
> > > > > adding "IMEX=1" please can someone give me an idots guide how I go
> about
> > > this!
> > > > >
> > > > > Where / how do I add the statement, is it within Excel ?
> > > > >
> > > > > Thanks in advance.
> > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>

I don't think you can set the extended properties manually. I would suggest
recording the action of making the query. Then use the article referenced
to see how to mdoify the connection string (in the recorded macro) to add
the extended properties. I haven't done it, but that is what I would try.

If that doesn't work, then I guess you would have to go to ADO as in the
article.

--
Regards,
Tom Ogilvy

"Jeff" <[email protected]> wrote in message
news:[email protected]...
> Hi Tom,
>
> Thank you for your time and effect, much appreciated.
>
> I think the area of programming is a step too far for me.
>
> In your reply you said you didn't really know what I was trying to
achieve,
> basically it was this:
>
> I have a master spreadsheet which imports data from several Excel
> spreadsheets via the "Import External Data" option, the error I was
getting
> was NULL cells, which I now know is due to mixed data types.
>
> I can follow the registry fix but have now idea how to add the connection
> string (If this is the right terminology to use) due to the liminations of
> the Jet Driver.
>
> You state the code is added in the marco field but no marco's are used for
> this import only the "Refresh" option.
>
> I hope this makes sense.
>
> Thanks
>
>
>
>
>
> "Tom Ogilvy" wrote:
>
> > Perhas that answer was too quick since I don't really know what you are
> > doing. Perhaps invest some time reading this link and see if you can
adapt
> > it:
> >
> > http://support.microsoft.com/default...b;en-us;257819
> >
> > This was in the original link as well. (there is a second link there
you
> > might want to check as well).
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Jeff" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi Tom,
> > >
> > > Does this code get copied into the "Visual Basic Editor" area of
Excel?
> > >
> > > Thanks
> > >
> > > Jeff
> > >
> > >
> > >
> > > "Tom Ogilvy" wrote:
> > >
> > > > There is sample code in the thread to which I posted a link.
Perhaps
> > you
> > > > should look at that. Otherwise, I guess I don't know what you are
> > doing.
> > > >
> > > > --
> > > > Regards,
> > > > Tom Ogilvy
> > > >
> > > > "Jeff" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > Thanks Tom for the post. I'm still at a lost to know how to add
the
> > > > > connection string:
> > > > > Setting "IMEX=1" in the Extended Properties section of the
> > > > > > connection string.
> > > > >
> > > > > Where do I add these statements? I'm sorry but I'm a complete
amateur
> > at
> > > > > this and would be grateful for an idiot guide.
> > > > >
> > > > > Thanks
> > > > >
> > > > > "Jeff" wrote:
> > > > >
> > > > > > I'm trying to import data from several Excel files into one
single
> > > > workbook
> > > > > > but having a problem with blank cells. I now understand this is
due
> > to
> > > > mixed
> > > > > > data types.
> > > > > >
> > > > > > I 've updated my registry key to Zero "TypeGuessRows" What I
don't
> > > > > > understand is the connection string which needs the following
> > statement
> > > > > > adding "IMEX=1" please can someone give me an idots guide how I
go
> > about
> > > > this!
> > > > > >
> > > > > > Where / how do I add the statement, is it within Excel ?
> > > > > >
> > > > > > Thanks in advance.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >