DateTimeFormat Schema setting 
Author Message
 DateTimeFormat Schema setting

Hello there,

Could anyone help me with the following problem: -

I have a Jet database located on one machine and require to export a table
containing date information. The date information is stored in UK
international form.

I am using: -

db.Execute "SELECT * INTO [Text;database=path].filename FROM Table"

To export the data.

I require this to be then imported onto a computer with US International
settings using: -

db.Execute "INSERT INTO Table SELECT * FROM [Text;database=path].filename

Since the exported file has dates in UK format they are corrupt when
imported into US machine.

What settings need to added to the Schema.ini file to achieve this.

Thanks in anticipation


Mon, 08 Apr 2002 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. How to set a Schema programmatically for Xerces-j

2. Set Schema problems

3. how can I set system-wide default schema?

4. "set current schema" and commit

5. Cannot set SCHEMA in db2cli.ini

6. set schema in visual explain...

7. set current schema

8. Set schema="yourdb"



11. SET CONSTRAINTS not schema-aware

Powered by phpBB® Forum Software