External Data

Kathleen0422

Board Regular
Joined
Apr 12, 2006
Messages
188
Hi All,

I am about to pull my hair out right now. Sure hope someone can give me some guidance.

I have an Excel Spreadsheet that pulls information from an access database. My macro refreshes the data. The recordset that is returned is less than 20 rows however there are 83 columns of information.

If I open the access database and look at the recordset that is returned I have data in the columns. However in the Excel Spreadsheet the last columns of data are returning with 0's can someone please tell me what I am doing wrong?

Thanks for your help in advance.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Kathleen,

You may want to provide the relevant macro code, as well as an example of the data you're pulling, to get help faster.
 
Upvote 0
Sub SetSales()

Cells.Select
Selection.ClearContents
Selection.ClearFormats

Application.ScreenUpdating = False
Application.DisplayAlerts = False

Range("A6").Select
Selection.QueryTable.Refresh BackgroundQuery:=True

Here is the code, the data that is returned is all numberical with the exception of column B which is the SKU
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

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