T
thorgal256
Hello I am using "excel ->Data->Import External Data ->Import Data" to copy
columns from an excel file (lets call it f1) to another one (f2).
It works fine but when there is alternatively figures and letters in the
column rows in f1 query will only import either figures or letters or cells
containing both.
See below for an example:
f1 -> f2
1 ->
a -> a
2 ->
b -> b
3 ->
d -> d
1a -> 1a
2b -> 2b
3d -> 3d
Can anyone please tell me how to import figures as well as letters when they
are located in the same Column ???
When trying to edit the query here is the code I get:
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=D:\file1.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 in advance
columns from an excel file (lets call it f1) to another one (f2).
It works fine but when there is alternatively figures and letters in the
column rows in f1 query will only import either figures or letters or cells
containing both.
See below for an example:
f1 -> f2
1 ->
a -> a
2 ->
b -> b
3 ->
d -> d
1a -> 1a
2b -> 2b
3d -> 3d
Can anyone please tell me how to import figures as well as letters when they
are located in the same Column ???
When trying to edit the query here is the code I get:
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=D:\file1.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 in advance