Suppose data, such price, is kept in a text-file (non-ODBC) and other product data is kept in ODBC databases and they need to be linked, what would be the best solution?


Douglas Hackney's Answer: Parse the text data out into a delimited file and either go after the file itself or load it into a relational ODBC source. You could use VB or VBA in XL to parse the data.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access