Hi! Just to let you know, I am not a novice in Access, but the databases I have developed have been simplistic and have not included any VBA programming. I have, within the last 4 months begun to use macros. I developed a database to track employee training. Employees are required to read certain assigned documents. The documents are constantly revised and therefore have revision numbers. I am transferring 100,000+ training records from an APPX application into my ACCESS database. I want the revision levels to appear in a decimal format in the Employee Training Record - example: 2.0, 4.0, 0.20040101, 0.20050304, etc. The Employee Training Record is a report in Access. The training records are stored in a table. The report is based on a query. I have tried numerous variations of formatting, but the best I have achieved is the revision level displaying in the report like 2.00000000. However, the 0.20040101 revisions always round to 0.00000000. The APPX application transfers them in a number format. I have not been able to change them to a text format, which is how I believe they would display properly. Can you help?
A large couple of solutions to repair Microsoft Access Databases from severe corruption. Both you may choose a paid tool just to save time and energy, or you may go along with an built in solution or a hands-on solution to repair Gain access to Database file.
You can repair Access database using an Access Database Restoration tool which is developed by one of the finest software developers in email and database software management industry. I am recommending this tool as System Info Tools also specializes in after sales service where many other software providers fail.
To know more about dis topic visit our site-
Microsoft MS Access SQL Certification Practical Training Course Institute...
Microsoft MS Access SQL Certification Practical...
The short term job oriented...
Hi, the difficulty to solve your problem is that we are not familiar with Appx. I have faced this problem numerous time, but usually it was from Excel to Access. Now if you can transfer it to Excel then you can change the format in Excel to Text and import it into Access. I have also read a little of the Appx manuals and it says there that you can work with ODBC, are you using it? ODBC will create a connection between the APPX application Database and Access, you should be able to do your queries directly from the ODBC connection without the need to import the table. Here is a PDF manual of how to set it up from their website: http://www.appx.com/ftp/appx/documents/manuals/appx/appxodbc/current/appxodbc-manual.pdf I hope it helps, let me know and I will try to do my best to solve your problem. Daniel
Hi Gaye,
If you can see the correct results on Excel you can change the format of that field in Excel to Text. Save it as an Excel file (VERY IMPORTANT) and then import it to access, when you import it make sure that the field in Access is Text as well. I just tried it and it worked fine on Access 2007 for 0.20040302.
you can also use Pivot table to create queries at Excel as well, but you have to save it as an excel file first(But thats a whole different issue).
I think that the first option should work for you just fine, let me know what happened
Daniel
×
293 views
Usually answered in minutes!
Hello, Daniel. Thank you so much for your response. Unfortunately, I am not able to make the ODBC connection without a request to our IT group. This would not be approved at this time. I transfer the APPX file through an FTP program. It comes in a .csv file. I have tried both a direct import to Access from the .csv file and saving the .csv to an .xls file and then importing. It appears to me that Access will only round the 0.20040302 type number down to zero (o.o). I can't find a way to get it to NOT round the number. Is that possible in Access?
Gaye
×