15 July 2010

Weekly Review: Table Import

There is a little GP tool that comes as part of Integration Manager. It's called table import. Basically this little guy will let you import a tab or comma delimited file into ONE table in GP. You can't combine tables, you can't link stuff, etc. This tool is a hammer, not a Swiss Army knife.
But it can be useful for tables not available in IM (like sales tax rates).

The astute DB's in the audience are asking why they would use Table Import when they can just use the fabulous tools in SQL server. Well, Table Import does provide the table specifications and some basic error checking while setting up the import, to make sure that you aren't screwing up the GP tables. So if you are not familiar with the wonderfully exotic table structure the basic error checking could save your behind.

Table Import is available in GP via Tools->Integrate->Table Import. This tool is so straightforward that if you've ever imported anything, you'll probably get it. If you've never imported anything, pretend this post doesn't exist and call your DB for help. Yeah. The one I just drove away.


Originally Posted by Mark at 9/28/2007 10:10:00 AM