using query to copy both letters and figures from and in the same

[Guest]

Hello I am using query with excel 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 ???
Thanks in advance

Sam

 

[Jeff Boyce]

It sounds like you may be letting Access decide what the data type is.

If you create a query against your Excel1 "table", and you explicitly coerce
the value in a field to be "text" (check Access HELP on CStr() function),
you will be assured of having "output" in the data type you wish.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

Thank you for the answer but I am not using Access at all, only Excel, I
posted this question here because it's the only place dedicated to Query.
So again my problem is how to import both figures and numbers located in the
same column with Query from an Excel file to another Excel file. I am not
using Access. If you think I should post this question somewhere else please
let me know.

 

[Jeff Boyce]

Post in an Excel newsgroup. This one is dedicated to MS Access queries.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/