OBDC Data Formatting

=?Utf-8?B?Sm9uYXRoYW4=?=

Guest

Posts: n/a

23rd Jun 2006

Hi,

I can't find a NG for ODBC in excel so I hope you can help me? We query a
SQL database that holds dates in the datetime format i.e. dd/mm/yyyy hh:mm:ss.

We normally force formatting on this column to send the data to Excel by
forcing it using +Year, +Month & +Week in our legacy databases now we have
swapped to SQL Query doesn't recognize the function +Week but does the others.

How can I get Query to set the column to diplay the week number once it
returns the data to excel?

TIA

« Default settings not applied to new documents | custom autofilter dropdown »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OBDC Database I don't want to change the data	=?Utf-8?B?VmljdG9yIFRvcnJlcw==?=	Microsoft Access VBA Modules	8	18th Apr 2007 06:00 PM
Importing access data from an OBDC data source	=?Utf-8?B?QXJ0?=	Microsoft Access External Data	1	30th May 2006 05:01 PM
How to remove OBDC Machine data source	=?Utf-8?B?VGh1eQ==?=	Microsoft Access	1	14th Mar 2006 04:09 PM
OBDC data problems	AKgirl	Microsoft Access External Data	0	17th Feb 2004 03:10 AM
Creating asp file, from access, and the obdc	Mike	Windows XP Networking	0	11th Jul 2003 05:42 AM