- Joined
- 5/6/06
- Messages
- 384
- Points
- 28
I am trying to import data from couple of spreadsheet and text files. For Excel files, I may just need range or some columns from each of the file...also part of the text file. It's simple to import the whole file, and then save to assigned table. My problem is, the files come from Prime Broker everyday, how can make the process automatic instead of setting the range mannually every day ?
And does anyone meet this kind of problem before: some of the Excel file with headers in merged cells, then Access can't even open the file....but if I manually remove the header, then it works...:smt100:smt100:smt100
Can anyone give me a hint on how to make it smooth and efficient ? Thanks a lot.
And does anyone meet this kind of problem before: some of the Excel file with headers in merged cells, then Access can't even open the file....but if I manually remove the header, then it works...:smt100:smt100:smt100
Can anyone give me a hint on how to make it smooth and efficient ? Thanks a lot.