issue in exporting data from Access to Excel - getting no data in excel

[SKV]

Hi,

I have used this standard code many times in the past with success to export data from Access to Excel file.

StrFileName = strFilePath & "SnOP_DP_FL01_DPData" & strDateTag & ".xlsx"
DoCmd.TransferSpreadsheet acExport, 10, "tempaaaaaaaaaaaaaaa", StrFileName, True


For some reason, now when I export the data, I get a file but with NO data. the tab name comes with some weird name as A266FF2A662E84b639DA

Please advise as what I should do to fix this error

 

[GinaWhipp]

Hmm, can we see the entire section, seems like there are lines missing. Also, what version of Access and Excel?

 

[SKV]

I have access 2010 and excel 2010. Yes there are no records in the exported excel file.

 

[Joe4]

Gina is right in that there are lines of your code that are missing (meaning you haven't posted them here), like the lines that define "strFilePath" and "strDateTag". So can you please post the entire relevant section of VBA code that applies to this?

Also, try adding this line before the "DoCmd.TransferSpreadsheet..." line:

MsgBox "There are " & DCOUNT("*","tempaaaaaaaaaaaaaaa") & " records in tempaaaaaaaaaaaaaaa to export"

And tell us what it returns.

 

[SKV]

The code used to work before, I just pasted the snippet of the code in this forum. There is something else going on as the tab name (A266FF2A662E84b639DA) in the exported file has some kind of indication of the error as if you google A266FF2A662E84b639DA you will see some posts (trying to read through but not able to resolve yet).

Let me know if you still want to see the full code.

 

[GinaWhipp]

Hmm, Google is your friend! I just put it in a Google search and see it is an issue when exporting to Excel. My thought would be once you work your way thru that if you still don't find an answer then post the whole section of code. BTW, thanks for the update!

 

[SKV]

Thanks for responding..the code worked today (and I did not make any changes).....so dont know this was just a random issue.

 

[GinaWhipp]

Well, we're here if it stops again!