Importing External Data

M

Mark

I need to import some data into excel. When I
select "Import External Data" from the data menu, it
works. However if I want to add more data from another
source, most of the options on the Import External Data
menu are ghosted out. WHY ?? Is it not possible to import
data from multiple sources into the sane worksheet ? Can
anyone offer any advice please..

Thanks

Mark
 
A

Arvi Laanemets

Hi

You can't retrieve data from various sources in same query, but you can
create a new one with different destination. But not into same column(s)

Arvi Laanemets
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import external data 6
Import External Data by Date 2
Templates 1
Import external data link disappears 1
How to remove headers when importing from an external source? 1
How to Create a Macro to Import External Data 0
Excel Import External Data by Date Automatically 0
How do I import external data and create two formats? 1

Top