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

T

thorgal256

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
 
J

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/
 
T

thorgal256

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.
 

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

Top