SQL syntax - defining the format of a field

[lovallee]

Hello,

I use ADOBD.Connexion / Microsoft Jet SQL to connect to Excel tables and create a pivot cache.

I need to understand the required SQL syntax to define a field format.

Exemple:

SELECT Table1.Field1 FROM Table1

And I need Table1.Field1 to be treated as text

How can I set the format of a field in my SQL statement?

Thanks!
Louis

 

[Mark W.]

Louis, I used my recommended SELECT in an embedded query that obtains it's data from an Excel workbook and returns it's results to an Excel workbook. While you might believe that TRIM is exclusively an Excel built-in function that's not the case. TRIM and STR are recognized by both Microsoft Access and Microsoft's Jet Db engine.

See....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctstr.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctltrim.asp


PS: Generally, I try out my recommendations before posting.

 

[lovallee]

Oupsss

You are right Mark. Sorry about that...

Let wait to hear from AC3100 if that worked for him.