Copy & Paste GUID from MS Access to Excel

M

MSPLearner

Is there a way to preserve the GUID column content when copy/psate to Excel?
I frequently running MS Access queries against the Reporting DB (Project 2007
Server) and need to paste the result in Excel, but any GUID columns are not
copied, instead I see a rectangle symbol.
 
M

MSPLearner

Thanks Rod,

This is after the I cut & paste? Sorry, I am not that familiar with string!
 
R

Rod Gill

No, in Access use a convert function to make sure the GUID is presented as a
string before copying. Try creating a query of the data you want and use
strGUID: Cstr(GUID) for the GUID.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
M

MSPLearner

OK, I will try it out. Thx

Rod Gill said:
No, in Access use a convert function to make sure the GUID is presented as a
string before copying. Try creating a query of the data you want and use
strGUID: Cstr(GUID) for the GUID.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Click to expand...
 
M

MSPLearner

Rod,

Thanks, it works.

Dinesh

Rod Gill said:
No, in Access use a convert function to make sure the GUID is presented as a
string before copying. Try creating a query of the data you want and use
strGUID: Cstr(GUID) for the GUID.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to excel from word - auto format problem 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Copy and Paste Special in Excel #REF error 1
Malformed GUID error 2
Project Server and timesheets 1
How to generate a GUID in SQL Server via Access 2
how to copy and paste value from one sheet to another 4
Combo box not displaying field from SQL backend 0

Top