PDA

View Full Version : Query in excel not importing numbers, just text.



NY2DR
11-16-2006, 08:33 AM
Hello,
I have this situation which I cannot solve:

I use the Data-Import External Data-New Database Query-"Excel files" to import a sheet from an excel workbook to a new workbook.

Everything gets imported exept the dates from the column field called "date fixed". In this field I have both dates and "XXX" in it.
Example:
What I need What gets imported Dates fixed Dates fixed xxx xxx 10/01/06
XXX XXX 11/06/06
xxx xxx 12/01/06
xxx xxx XXX XXX
The "xxx" gets imported, but anything that is a date or even looks like one does not.

In access I don't have this problem. I wonder what else I can do to overcome this?:think:

Thanks

mdmackillop
11-16-2006, 02:24 PM
Can you post a small sample?

NY2DR
11-17-2006, 09:08 AM
Thank you for responding,

The sample is attached.

There are 2 tabs, One "Original", the other "Query".

The Query sheet is the one that will not show both "Dates" and "xxx"'s on column "C". (Before, it wasn't showing the Dates??????)

This is just a simple query from excel, what am I missing???:think:

Normally, I use the Data-Import External Data-New Database Query-"Excel files" to import a sheet from an excel workbook to a new workbook

Thanks,

lucas
11-17-2006, 09:17 AM
the sheets seem to be identical...why not just copy the sheet to a new workbook?

Norie
11-17-2006, 09:23 AM
Why do you have the XXX/xxx in the cells without dates?

That's probably causing Excel to regard that field as text rather than a date.

NY2DR
11-17-2006, 09:48 AM
Thanks for replying guys,


For lucas' question: The sheets are identical to show that the dates were not imported. I want to query any Dates or even "xxx"'s into another sheet. You will notice that the "xxx"'s dont show, and for this query, I want everything to show.

For Nories' question: This tells me that it is an invalid error, that it should not be followed up on. I also want everything to show as an example, so that can see that not all cells have been imported as it should have.

For this query, what I want to do is to be able to query anything from column "C" so that I may know how many errors were fixed by a certain date. I can filter it from the original sheet, but then it will have to be in a shared format, and to filter it (20,000 lines) takes tooooooooooooo loooooong.
So, I want to query that information from another workbook so that I won't interfere with anyone elses work.

I hope that gives you more information.

Thanks,