Changing Data Format

  • Thread starter Thread starter E. Ehrhard
  • Start date Start date
E

E. Ehrhard

I am bringing over data via ODBC linked table. One of the
fields is linked to several other tables that I have. The
issue is the linked table's data is formated as number and
all of the other data sources are text. Is there a way
through a query possibly to change format of the data?

Thanks

E
 
E. Ehrhard said:
I am bringing over data via ODBC linked table. One of the
fields is linked to several other tables that I have. The
issue is the linked table's data is formated as number and
all of the other data sources are text. Is there a way
through a query possibly to change format of the data?

Thanks

E
Click to expand...


SELECT CStr(L1.NumberField)
FROM LinkedTable AS L1

The output of this query will be text-type data.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format DATETIME to Date in query on linked table 4
Data/Values change when Query Analyzed in Excel 3
change data type in query through a link table 1
Data Not Displayed in Query 2
Data changes when Analyzed with Excel 2
Split data in field on character return 0
Type Mismatch in Expression 4
Linked Tables - adding field and getting overflow error 1

Back
Top