Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing of special characters from Excel

Status
Not open for further replies.
tjessejeff

tjessejeff

Programmer
Jan 28, 2002
34
US
Hi,
I have a problem. I imported an Excel spreadsheet into Access. In column A, I have a field that is displaying special charaters for some cells and not for others. These characters are throwing my duplicate search off. Because of these characters, elements that are duplicate appear to be not. How came I automate getting rid of these characters in this column. The spreadsheet is producted from an extract routine in Lotus Notes.
 
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
176
Viswa.R
Viswa.R
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
335
Andrzejek
Andrzejek
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
245
Andrzejek
Andrzejek
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
255
SoftwareRT
SoftwareRT
JayRo71
  • Locked
  • Question
docmd.TransferText not importing a number field
Replies
1
Views
199
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top