Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import external data | Excel Discussion (Misc queries) | |||
Import external data | Excel Discussion (Misc queries) | |||
External Data Import | Excel Discussion (Misc queries) | |||
import external data | Excel Discussion (Misc queries) | |||
Import External Data | Excel Worksheet Functions |