How can I get a row of info using the import external data functi.
 

How can I get a row of info using the import external data function

I need help to know what's the code to enter in the command text box

Ty,

Alex

How can I get a row of info using the import external data functi.
 

Maybe you're talking about using MSQuery, by doing Data GetExternalData
CreateNewQuery ...then select a database and follow the menus.......

hth
Vaya con Dios,
Chuck, CABGx3



"Alex" wrote:

How can I get a row of info using the import external data function

I need help to know what's the code to enter in the command text box

Ty,

Alex

How can I get a row of info using the import external data functi.
 

Alex

Does anything here help

http://www.nickhodge.co.uk/gui/datam...rtexternal.htm
http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Alex" wrote in message
...
How can I get a row of info using the import external data function

I need help to know what's the code to enter in the command text box

Ty,

Alex

How can I get a row of info using the import external data fun
 

Thank-you. the 1st link answered my question. It seems i was trying to use an
ODBC function without configurating it properly.

Thanks again.

Alex

"Nick Hodge" wrote:

Alex

Does anything here help

http://www.nickhodge.co.uk/gui/datam...rtexternal.htm
http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Alex" wrote in message
...
How can I get a row of info using the import external data function

I need help to know what's the code to enter in the command text box

Ty,

Alex

How can I get a row of info using the import external data fun
 

Alex

Great glad it worked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Alex" wrote in message
...
Thank-you. the 1st link answered my question. It seems i was trying to use
an
ODBC function without configurating it properly.

Thanks again.

Alex

"Nick Hodge" wrote:

Alex

Does anything here help

http://www.nickhodge.co.uk/gui/datam...rtexternal.htm
http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Alex" wrote in message
...
How can I get a row of info using the import external data function

I need help to know what's the code to enter in the command text box

Ty,

Alex