removing space and " ' " from exporting data

removing space and " ' " from exporting data

Post by R0VPUkdJQ » Thu, 09 Jun 2005 02:16:02


I have created a database for my team, which has a command button. This will
export out a query into excel spreadsheet into our shared drive. The problem
is that when it is exported out, the data contains a space and " " " . You
will not see it unless it is clicked on that cell. For example: it will say
" 'Customer Name". This is causing problems when it is combined with
spreadsheet the team used prior to Database. (it doesn't contain space or " '
" ). When two spreadsheet is combined and sorted, it sorts the spreadsheet
produced from the database first, then the original spreadsheet. Is there
any way to have it exported out without those space and " ' " " ? Please
help. Thank you!