Hi everyone,

I'm using Import External Data with 2 excel tables as a relational
datasource as per the website tutorial "Use MS Query to Treat Excel As a
Relational Data Source http://exceluser.com/explore/msquery1_1.htm by Charles
Kyd.

My problem is that one column of data is either numbers or letters and when
I run the query the numbers are pulled out ok but the letters aren't.

My source data are two csv files that I copy to an excel book using Edit
|Move or Copy Sheet. Once the data is there as individual sheets in the book
I name the data tables for use in the query.

I'm getting round the problem by using auto filter and replacing letters
with numbers that will not appear within the data. This is fine for this data
as only numbers up to 10 appear with the data, but it's definitely not an
elegant solution.

If anyone could help, that would be brilliant :-)

Cheers
Diddy

Can't be certain without seeing your data, but:

Be sure you tell the Import Wizard that the field you are picking up is Text.

It should then be able to get both numerical and non-numerical data.
--
Gary''s Student - gsnu200858


"Diddy" wrote:

Hi everyone,

I'm using Import External Data with 2 excel tables as a relational
datasource as per the website tutorial "Use MS Query to Treat Excel As a
Relational Data Source http://exceluser.com/explore/msquery1_1.htm by Charles
Kyd.

My problem is that one column of data is either numbers or letters and when
I run the query the numbers are pulled out ok but the letters aren't.

My source data are two csv files that I copy to an excel book using Edit
|Move or Copy Sheet. Once the data is there as individual sheets in the book
I name the data tables for use in the query.

I'm getting round the problem by using auto filter and replacing letters
with numbers that will not appear within the data. This is fine for this data
as only numbers up to 10 appear with the data, but it's definitely not an
elegant solution.

If anyone could help, that would be brilliant :-)

Cheers
Diddy

Hi Gary''s Student,

Thanks for replying.

How do I go into the Wizard?

I'm using new database query and the Excel files from the dialogue box
select workbook and then add tables.

Can I specify data type this way?

Cheers
Diddy



"Gary''s Student" wrote:

Can't be certain without seeing your data, but:

Be sure you tell the Import Wizard that the field you are picking up is Text.

It should then be able to get both numerical and non-numerical data.
--
Gary''s Student - gsnu200858


"Diddy" wrote:

Hi everyone,

I'm using Import External Data with 2 excel tables as a relational
datasource as per the website tutorial "Use MS Query to Treat Excel As a
Relational Data Source http://exceluser.com/explore/msquery1_1.htm by Charles
Kyd.

My problem is that one column of data is either numbers or letters and when
I run the query the numbers are pulled out ok but the letters aren't.

My source data are two csv files that I copy to an excel book using Edit
|Move or Copy Sheet. Once the data is there as individual sheets in the book
I name the data tables for use in the query.

I'm getting round the problem by using auto filter and replacing letters
with numbers that will not appear within the data. This is fine for this data
as only numbers up to 10 appear with the data, but it's definitely not an
elegant solution.

If anyone could help, that would be brilliant :-)

Cheers
Diddy