Excel > MS Query

[MarkAndrews]

Guys, I really need an answer to this

I have a large dump of data which i am extracting by month onto seperate sheet tabs (Jan - Aug)

When selecting all the data, it wont copy over certain dates (specifically in the 'AbortDate' column)

Any idea's? TIA

SELECT `Data$`.ClientID, `Data$`.IntroducerID, `Data$`.MatterID, `Data$`.StartDate, `Data$`.AbortDate, `Data$`.AuthActDate
FROM `\\hqnas01p\redirect$\mandrews\Desktop\Abort Data`.`Data$` `Data$`
WHERE (`Data$`.StartDate Between ? And ?)

 

[Harvey]

What code are you using to split the data?

 

[MarkAndrews]

The one above? Well thats the SQL anyway

 

[Richard Schollar]

Mark

When you say that it isn't copying over all the dates, do you mean after the data has been imported into the spreadsheet using MSQuery or do you mean the actual query itself isn't bringing over the data? If the latter, the obvious question is: are you sure the database has data in this field to begin with?

Best regards

Richard

 

[MarkAndrews]

Mark

When you say that it isn't copying over all the dates, do you mean after the data has been imported into the spreadsheet using MSQuery or do you mean the actual query itself isn't bringing over the data? If the latter, the obvious question is: are you sure the database has data in this field to begin with?

Best regards

Richard

There is definitely data in the field (Hense the 'NULL')

The data tab (where the query gets its data) is a pre extracted dump of data from the database (its not a live SQL feed from the DB)