Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 493
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,173
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 493
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,173
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import external data ana garcia Excel Discussion (Misc queries) 2 April 29th 06 04:05 AM
Import External Data Non-HTML Table Jay637 Excel Discussion (Misc queries) 0 March 9th 06 04:37 PM
Import External Data Susie Excel Worksheet Functions 0 July 29th 05 09:12 PM
How do I import external data populate rows instead of columns. KWE39 Excel Discussion (Misc queries) 0 July 1st 05 09:53 PM
Import External Data Martin Excel Worksheet Functions 1 February 9th 05 06:14 AM


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"