Home |
Search |
Today's Posts |
#1
|
|||
|
|||
importing data from access
when importing data from access, i have one column is a unique identifying
number. HOwever, the number comes in with { } around the #. How can i remove them. thanks Jerry |
#2
|
|||
|
|||
jerry wrote: when importing data from access, i have one column is a unique identifying number. HOwever, the number comes in with { } around the #. How can i remove them. thanks Jerry Once in Excel, do a find and replace. Twice, once for {, and then repeat for }. Leave the "replace with" blank, and "replace all" both times. pierre |
#3
|
|||
|
|||
I don't speak Access, but couldn't you just select your range and do:
Edit|Replace what: { with: (leave blank) replace all then once more for the close bracket } jerry wrote: when importing data from access, i have one column is a unique identifying number. HOwever, the number comes in with { } around the #. How can i remove them. thanks Jerry -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing data from txt file | Excel Discussion (Misc queries) | |||
my data truncates when ported from access to excel | Excel Worksheet Functions | |||
How do I prevent data truncation from access to excel using MS Qu. | Excel Worksheet Functions | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
MS Excel data reading in MS Access | Excel Discussion (Misc queries) |