Excel > MS Query

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
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

Code:
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 ?)
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

Well-known Member
Joined
May 2, 2006
Messages
1,963
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)
 

Forum statistics

Threads
1,137,301
Messages
5,680,705
Members
419,929
Latest member
Atlas Quinn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top