Import External Data

[Bongard]

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 are:
Win XP Pro SP3
Excel 2003
Add-ins checked are the same

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

 

[Eva]

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.

 

[Bongard]

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;Mode=Share Deny
Write;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDBatabase
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 OLEDBon't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

Thanks,
Brian

 

[Eva]

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.