Importing a csv via code
Posted on 2011-03-11
I need some help with syntax for importing a file within code.
I'm unfamiliar with file manipulation commands.
How do I automate an import for users? The file will always have the same format, but it won't always be named the same thing or be in the same folder location on the user's computer.
So i need the code that will:
1. prompt the user for the file location
2. import the data using my saved import ("Import-MyData")
3. let the user know if the import failed because they picked a file without the proper format.
Thanks so much for the help.