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