Excel > MS Query

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,970
Office Version
  1. 2010
Platform
  1. Windows
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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,218,837
Messages
6,144,755
Members
450,567
Latest member
Mplz

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
Back
Top