| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
issue with excel 2003 data import
I am having a little problem with the way excel 2003 importing data from
another worksheet. If the column (within a table) has mixed data (text & numeric), only data that has the same type with the first row data type will show up. For example, if the first row was numeric, all non-numeric will not show up and vice versa. I am attaching the automated code by excel here for your reference. Please help me to resolve this issue because it would be useless to import part of my table (as a pivot or table) into another worksheet. Please and thanks, LT Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=I:\PERSONAL DIRECTORIES\LNguyen\Morning Star\Ivy.xls;Mode=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is the Template Wizard with Data Tracking Excel 2003? | Excel Discussion (Misc queries) | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| Import NMEA data to excel? | Excel Discussion (Misc queries) | |||
| Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
| How do I import MS Project data into Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
