CODEWITHSUNDEEP
excelms-accessvba
darkjh
darkjh

Reputation: 2861

Copy/paste between Access and Excel

in one of my form in Access, i want to put together some texts in a string, then my user can copy this string into Excel, in different columns. For example, there are 5 letters in my form: A B C D E, when the users hit a button "copy", then do the paste in Excel, say in the case A1. Then the 5 letters will be pasted into 5 columns in one row:

A1 B1 C1 D1 E1

A B C D E

What i am searching is whether there is a symbol just to indicate the end of a column.

Upvotes: 3

Views: 1370

Answers (1)

Brian Willis
Brian Willis

Reputation: 23854

You can use tabs between each value, and Excel will break the data up into columns when it's pasted in.

Upvotes: 1

Related Questions