I haven't used .net unfortunately. I'll definitely check it out though. As for the tabbed format to open in Excel; that would work for the formatting--is there a way to automate it? I'm guessing there probably is--I just haven't figured it out. Possibly a macro running automatically upon opening Excel? Text-to-columns won't work unless it's part of a macro. Because of the funky date formats, I'd have to split columns & take some extra steps which keeps messing up the automated part. That's why I was sorta leaning toward using SQL to set up the format initially--in the query. But again, I could be way off. I love the whole idea of going direct to the database using .net because you mentioned that it works with SAP too--that would be perfect. Thanks for the input. This has to be easy for some of you Excel/FileMaker gurus...please tell me how you have handled this in your past experience!
Main Topics
Browse All Topics





by: ged325Posted on 2009-03-13 at 13:32:05ID: 23883239
What if you did the tabbed format but opened in excel? Also have you looked into the text to columns?
The best way for me would be to program the input in .Net and upload directly to the database, reading the files as they come in. .Net could also pull your info from SAP for you.