#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Import External Data

Hi, I have a spreadsheet where I'm importing external data from
another MS Excel spreadsheet. I have a macro created to run off the
query results etc... The odd thing is, when I run this on other
computers the external data query doesn't import one of the columns
from the other Excel file and for the life of me I can't figure out
what is different between the 2 pc's. Has anyone seen behavior like
this before?

Also when I try to create the query from scratch on the other
computer, I'm not able to bring in all the data that way either. I
still am missing a column.

All computers a
Win XP Pro SP3
Excel 2003
Add-ins checked are the same

Any help or ideas would be much appreciated - Thanks!
Brian
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eva Eva is offline
external usenet poster
 
Posts: 197
Default Import External Data

is it possible that column heading has been changed?
Check : Data./Import external data/edit query
and then make sure that the column has been added to a link.

--
Click yes if helped
Greatly appreciated
Eva


"Bongard" wrote:

Hi, I have a spreadsheet where I'm importing external data from
another MS Excel spreadsheet. I have a macro created to run off the
query results etc... The odd thing is, when I run this on other
computers the external data query doesn't import one of the columns
from the other Excel file and for the life of me I can't figure out
what is different between the 2 pc's. Has anyone seen behavior like
this before?

Also when I try to create the query from scratch on the other
computer, I'm not able to bring in all the data that way either. I
still am missing a column.

All computers a
Win XP Pro SP3
Excel 2003
Add-ins checked are the same

Any help or ideas would be much appreciated - Thanks!
Brian
.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Import External Data

Thanks for the reply EVA. When I click Edit Query it brings up "Edit
OLE DB Query" I only have the option of editing the connection string.
I'm not sure where in here the columns would be specified.

Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\
\lbprds0262\vol3\Eqprod\PAB\IPOCAPWGHTS_GRPS.XLS;M ode=Share Deny
Write;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database
Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global
Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

Thanks,
Brian
  #4   Report Post  
Posted to microsoft.public.excel.misc
Eva Eva is offline
external usenet poster
 
Posts: 197
Default Import External Data

There are two ways to link excel files (data/import external data/)
1-by import data
2-by new data base query
When you link by new data base query and then click edit query it should
open the ms query wizard and let you see your data where it is linked.
When you link by import data then you get the info as below.
I advise to insert a new sheet, link it again by using new data base query
functionality- it gives us more flexibility in cases where something is wrong
and you need to see the source or you need to add more data from the other
sheet.
--
click yes if helped
Greatly appreciated
Eva


"Bongard" wrote:

Thanks for the reply EVA. When I click Edit Query it brings up "Edit
OLE DB Query" I only have the option of editing the connection string.
I'm not sure where in here the columns would be specified.

Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\
\lbprds0262\vol3\Eqprod\PAB\IPOCAPWGHTS_GRPS.XLS;M ode=Share Deny
Write;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database
Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global
Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

Thanks,
Brian
.

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 Swan0tree Excel Discussion (Misc queries) 2 October 1st 09 10:19 PM
Import external data juanpablo Excel Discussion (Misc queries) 1 January 22nd 08 02:54 AM
External Data Import MikeD1224 Excel Discussion (Misc queries) 1 February 16th 07 11:22 PM
import external data ana garcia Excel Discussion (Misc queries) 2 April 29th 06 04:05 AM
Import External Data Jeff Excel Worksheet Functions 0 May 3rd 05 10:28 PM


All times are GMT +1. The time now is 04:10 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"