issue with excel 2003 data import

L

LNguyen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Globally change an Access connection string 0
Not All Data Being Imported 0
Excel2007 Pivot Table -- internal settings 0
Ignore table formatting when importing data using OLEDB 0
Importing data from an excel file to another with figures and lett 0
Data source 0
USING FIELD DATA FROM USERFORM 0
Connection String problem 1

Top