December 14, 2005 at 9:13 pm
I found several versions of how to check if a column exists in the database, but what about if it's being imported from a dbf file? I want to check that a column exists before trying to select it from the dbf file to be imported into the database. If if does not exist, with the exception of a few columns, I want the system to not have an error, and just continue importing other columns that are found. The dbf files will always have some matching columns, but some will not always be there, which ones vary. So I have a list of columns to check for, but I don't want the import to abort just because a non-critical column is missing.
Suggestions?
Thanks.
December 15, 2005 at 12:42 pm
Sorry, but some times, when I posted in other forum categories that were more relevant to the question, I received ZERO responses, but actually received some responses to the same posting in seemingly less relevant forum categories. Sometimes the posting covered more than one forum category, (such as taking either a DTS or sql approach to a solution). The DTS thread responded with both DTS and SQL possibilities, but still zero response from the SQL or newbie threads. Some times it wasn't clear which would be the best area to post in, and sometimes it covered multiple categories.
Again, sorry for the cross posting, and when possible I will avoid it when I can.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply