I am attempting a new project to add to an existing database and some initial guidance would be appeciated.
I am trying to import orders raised from a seperate "design" program. The program saves the order in note pad. I have played around with the "get external data" wizard and seems to be what I am after as I can get the (very) basics working but.......
1 In the notepad file I have to delete an address at the top and blank lines at the bottom in order for only the product code / description / qty lines to be picked up. Is there a way only to pick up certain data only?
2 In importing the data is there a way to add an extra field in repsect of the whole data - ie in this case a customer number (already in the main database) - one customer many lines to the order
3 Is there an (easy!) way to automate the whole procedure - Ie - click on a button and it will bring up a browse function to select the file - pick the file - and import / append to table automatically. At the moment there is alot of changes in terms of skipping certain fields and amending the layout of the field sizes each time I try to import.
I appreciate I am asking alot, so some guidance as to if it can be done and if I am thinking along the right lines initially would be appreciated.
Many thanks
Richio
I am trying to import orders raised from a seperate "design" program. The program saves the order in note pad. I have played around with the "get external data" wizard and seems to be what I am after as I can get the (very) basics working but.......
1 In the notepad file I have to delete an address at the top and blank lines at the bottom in order for only the product code / description / qty lines to be picked up. Is there a way only to pick up certain data only?
2 In importing the data is there a way to add an extra field in repsect of the whole data - ie in this case a customer number (already in the main database) - one customer many lines to the order
3 Is there an (easy!) way to automate the whole procedure - Ie - click on a button and it will bring up a browse function to select the file - pick the file - and import / append to table automatically. At the moment there is alot of changes in terms of skipping certain fields and amending the layout of the field sizes each time I try to import.
I appreciate I am asking alot, so some guidance as to if it can be done and if I am thinking along the right lines initially would be appreciated.
Many thanks
Richio