Unanswered: Importing data from .xls or other files in an Access Table
I need tot fill in daily hondreds of records in a database from a file i can easily export to excell or a text file or whatever. So i thaught i should automatise this and save a lot of time. But i really don't know where to start.
WHat i done a few times is moving rows and colums , copy paste and make that the columns in excell are the same numnber and format as in my Access table and then copy and paste to access. But to arrange all data in excell to same format and number of colums also takes a lot of time. And there is another problem ; if in excell i have qty 10 of one item i need to have 10 diferent lines in my table. So what i did in excell before is adding rows and copy same thing to 10 different rows.
Thank you for your advice. I tried it but all it does is link an excell table in acess. The problem is i need to import data from excell or other format file in an existing access table. I was more thinking of some visual basic code that will tell access to copy all data from column X from row Z to row Y and paste it in acees field F and so on....
Another problem is that on the data i have to imort the description is like : 10x Item1 and this should be translated to 10 separate records with identical informatin and not just one record with qty 10.
Don't forget the layout of my data in excell or rtf or whatever is not same as the layout in access. i wille have to skip some rows and colums and the nuber of rows can also be different every time.