Create CSV upload module in Microsoft ACCESS
Budget: $30 – $250 AUD
I will provide both teh Access Database and the CSV file that will need to be uploaded.
I have a file that I want to upload into an import table in an Microsoft Access Database that needs to be checked to avoid duplicating uploads.
It needs to ask for user input and reference a table to ensure that Source is a known input from tlbSourceDataReference. The two inputs used for verification will be Source and Supplier (this should be a dropdown box referencing suppliers in the table)
If the data checks out, the last check we do is in the tlbImportLog file using the Source (from tblSourceDataReferce), and the datastamp in the CSV and ensure it hasn’t already been imported. If it has then attached an error “File already imported” and end program.
Once the date is cleared the above checks we append the data in the CSV to the table imp - ??? that is referenced in the field ImportTable from tlbSourceDataReference.
Once appended we need to update the tlbImportLog with SupplierID, SourceID, DateStampUpload (this is the one in the file), Datestamp (this is when the file is uploaded), ImportID and Products in File (this is just the number of lines excluding heading).
I have a file that I want to upload into an import table in an Microsoft Access Database that needs to be checked to avoid duplicating uploads.
It needs to ask for user input and reference a table to ensure that Source is a known input from tlbSourceDataReference. The two inputs used for verification will be Source and Supplier (this should be a dropdown box referencing suppliers in the table)
If the data checks out, the last check we do is in the tlbImportLog file using the Source (from tblSourceDataReferce), and the datastamp in the CSV and ensure it hasn’t already been imported. If it has then attached an error “File already imported” and end program.
Once the date is cleared the above checks we append the data in the CSV to the table imp - ??? that is referenced in the field ImportTable from tlbSourceDataReference.
Once appended we need to update the tlbImportLog with SupplierID, SourceID, DateStampUpload (this is the one in the file), Datestamp (this is when the file is uploaded), ImportID and Products in File (this is just the number of lines excluding heading).