Reading a SQL table into Excel

D

David Vardy

We have an SQL table whose fields are all varchar (because
it is used as a temp holding area and the info in it may
be date, number, text etc depending on which report uses
it). This is read in to a recordset by a VB programme,
Excel is opened and the fields copied from the recordset
into the workbook one by one.

However, a date of 01/04/2003 in the SQL tablle appears as
04/01/2003 in the workbook. 14/04/2003 copies across OK
as does any date where the day is over 12.

Can you help us to stop this happening?
The Windows NT Region country settings are correct at UK.

Thanks,
David
 

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

Paste to excel from word - auto format problem 1
Distributing cell value (not text-to-columns) 7
Pass date from one form to another form in MS Access 1
Pasting a cell into bookmarked table from excel vba 1
If Statement to delete cell or retain contents 1
Pivot table Days to Months 0
Insert Index into a Table 1
Cumulative formula for word table 0

Top