PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
ACCESS-2003 Connector DateTime Problem
ACCESS-2003 Connector DateTime Problem
Started by Helmut RETZEK, May, 03 2022 6:58 PM - 1 reply
Connect yourself…
Helmut RETZEK
#1
Registered member
1 message
Posted on May, 03 2022 - 6:58 PM
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
Report
0
0
ClaudeSjDevinHenry
#2
Registered member
8 messages
Posted on June, 10 2022 - 11:17 AM
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.
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text