Search results

Hi all, I am done with the excel import file. I consider the thing done. I am adding the file here for others to use as an example. BIG Thanks to all that helped.

It is probably a language thing. I am struggling to explain it as the concept in itself a bit bizarre, but I cannot share any data as it is protected and confidential. I made test ty[pe spreadsheet just to see what is resulting when importing. So, to kinda go around the problem I have, I will...

I understand but the source file i provided are no where near what is going to be imported. It is imp,ortant for the user to override fields names. Most times the field name willnot match and searching for a match will not yield anything, but the informationm is there under another column name...

Pat, they are not the same. Because data is coming multiple software scattered in different divisions. But the field format are generally the same. As for the create on the fly, I would of done it, but the consensus seemed to be that you do not want fields generation as the form might lockup...

Hi Pat, thx for details. The point of using preset is that it is assumed that headings are matching. All the time. It also checks that they are Hence why I used the same column headers on each side. As for mapping, I am not trying to match field names, I am telling access to use what ever I am...

OK, I am adding the works that I did so far. I am at the stage where you can verify the file loaded in a temp table, I am trying to dynamically create the SQL to update or update+append to any table. The functions have a debug popup. You can turn them off by putting False in any function last...

Hi you all. Thanks again for giving me pointers as I am trying to figure this out. The setup is coming along. But I am hitting a problem. I am creating a table from vba with the required fields and it works fine, but I am unable to create a field in a combo list style to put in my heading...

Well, The exact thing but using a field mapping technique. You had me think yesterday and i think I will avoid object creator and opt for the setup of a temp table containing some of the information. Then I will pull it in a continuous subform for mapping.

OK, I think I got the PRESET (Excel matching table headers) working, attached are two picture, one when matching, or when not.

Hi, Lots to take into consideration. But for the data quality, I am not too worried as the excel are produce by a system and not a human (IBM DOORS). The validation should of been done there. But I would verify some column. As for the overwrite and multiple upload, it is not too important...

Hi, Thank for answering. So, the task at in itself is simple. I need to import data into an Access table using an Excel file. The scope is two fold: 1 - Using an Excel file with matching headers (verified header match prior to insert) This part I got it workng 2 - Using an Excel without...

The Excel files are given to me via USB stick to be imported into access. The Excel given to me are the main files used to update the tables and get a snapshot of the connected network. There is no middle-man here, simply an app in access that shows the data we need (intranet) to see from the...

OK, I will see and play a little bit with it. All tables are linked on a network drive, never to be accessed from a connected network.

Hi Pat Thx for looking this up! So from what you circled I can understand that if you save and re-use the form, it will actually keep in mind what was added and remove fromit. So, the debate is if the form is never saved, there would be no lifetime to start with, hence the data would be...

Sorry, i must of not be clear. And BTW, thank you for taking the time to discuss with me, that goes for all of the users that commented as well!!! :) I understand that if there is no change to tables and no save, everything should stay intact. Anyways, the form created would not be bound to any...

Thx, i'll give it a go.

Thx a bundle. Do you think that the method would create a problem with the loggin of info in Access. Cannot find anything that says Access saves the info if the form is deleted. ???

Thx for the warm welcome!

Yeah, I wanted to play with that too. That could be a good approach too. I am getting in deep of access by investiguating what is actually logged into the app and why , that way I can evaluate the limit problem a bit better.

Thx for taking the time, I will be investiguating the approach.