FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV 2024
→
ACCESS-2003 Connector DateTime Problem
ACCESS-2003 Connector DateTime Problem
Débuté par Helmut RETZEK, 03 mai 2022 18:58 - 1 réponse
Connectez-vous…
Helmut RETZEK
#1
Membre enregistré
1 message
Posté le 03 mai 2022 - 18:58
its just beautiful how easy I can import and use my old native ACCESS-2003 DB into Tables, sort and filter .....
but DATETIME Field exports only the DATE-Part if I update it or create a now record in the Database-Table.
in ACCESS the DateTime is stored: 44684,7886689815
front Part = Date
right part behind comma = time
ACCESS Datetime = 8 Byte REAL
tested around quite some time and find that WINDEV ACCESS JET-DB Connector imports DATETIME from ACCESS correctly but exports it just as an integer, not as a real (when exporting the WINDEV nativ DATETIME via DateTimeToReal () )
when I change the ACCESS-DateTime Field in the "Analyzer" to a REAL 8 BYTE then export is done correctly
but now the Table is not longer shown in the TABLE-Control (created every time a new table to represent the actual present state of the imported table)
Has anyone a working WorkAround ?
--
best regards
HeliRetzek, Austria
Signaler
0
0
ClaudeSjDevinHenry
#2
Membre enregistré
8 messages
Posté le 10 juin 2022 - 11:17
I would just try to import it as 1 or more text fields. There has to be a way. Once you get the text into a table converting it to actual date/time data will be easy and it can be automated in VBA as part of the import process. Some things to consider:
There are different types of text files and different character sets. Try saving it a different way. Open it in a text editor and save it from there. Open it in MS Word and try different text formats.
What is the delimiter? Try different ones.
There could be an invisible character Access can't handle that is part of this format. The first bullet may help with that.
Open it in excel and save it as one of the CSV formats.
Keep trying. I can't believe there isn't a combination of settings
https://voojio.com/chatroom/omegle
that
https://omegle.ws
will work.
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte