Experts -

I have a workbook with several links to an Access database that result in Excel being populated with a few small data sets/tables.

The problem is I cannot add the comma separator to some of the values (but not all).  Some of the columns work and some don't.

Any idea how to fix this?

Thanks in adv

Hi Bonediggler,

Based on your description, I still have some questions about your issue, please provide more information.

1. >>I have a workbook with several links to an Access database<<, please tell me the steps of linking to Access database.

2. >>add the comma separator to some of the values<<, did you add the comma sparator manually or by some functions?

I suggest you provide a sample file about your issue, you can send it to our email address:

ibsofc@microsoft.com

Please Note: Please add the url of this thread to your email or easy tracking.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Hi Bonediggler,

Based on your description, I still have some questions about your issue, please provide more information.

1. >>I have a workbook with several links to an Access database<<, please tell me the steps of linking to Access database.

2. >>add the comma separator to some of the values<<, did you add the comma sparator manually or by some functions?

I suggest you provide a sample file about your issue, you can send it to our email address:

ibsofc@microsoft.com

Please Note: Please add the url of this thread to your email or easy tracking.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Please provide a screenshot about your problem...

• Edited by guGuuuMy 23 hours 48 minutes ago