Search results

Yes, and if you read my post above..adding the "extra information"(the system time at the time of import) is just what i did to display the records in a specific order. Also this database was created before i was brought in to fix it, so there wasn't a way i could've controlled its design...

The_Doc_Man, I understand what you're saying about the flawed design...this database was long being used before i could get my hands on it and the users didn't want me to change its structure as it would mess up the reports that they work on. They only wanted to get around having to re-enter...

Ok, i added an interim table into which the records are first imported and then exported to the main table with the current system date/time attached to it. The next challenge is to have the form(with fields that are bound to the main table) to display the records that we just imported. That was...

Is there some line of code that i can add to my import function(above) so that it transfers the date/time on the form also to the table with each of these records?

There are no unique fields in the spreadsheet..thats the challenge that i faced, so i was thinking of working around it. I thought about having access add the system date & time to the records as they are imported, so each record would have a system date/time attached to it as an extra field...

Hello All, I have an MS Access table into which i import data from excel. I have an Access form that does this for me. My issue is that the data gets imported into the table but it gets stored at random areas in the table. It does not append to the beginning or end of the table but...

Ok, This is how i did it: Coded a 'browse' command button and 'import' command button to browse for and import an excel file. Did this by Copying and modifying bits and pieces of code from the "Browsing2" example by ghudson. But then i had a problem where the file would import to the table but...

Yes, I'd like to take a stab at it.

I understand... but is there a way to achieve the population of data on the forms? I'd like the "import" command-button to populate the excel-data onto the appropriate fields on the form first, and then manually enter some more data onto the same form and save all this data as a new record.

I did do a search, and i only found examples of importing the excel data into tables but not about populating it into forms..

Hello! I have an access database that is used to generate microbiology test reports; i want to be able to tweak it a little bit so that i can avoid redundant data entry. The way it is being done now is, data from food samples are entered(by sample collectors) into an excel file and sent to the...