Recent content by yazomoto

  1. Y

    Question How to import excel xlsx file to sql with changing header location and name

    Thank you for your answer. Yes ODBC is a good option to read excel. Reformatting the excel file is also ok but automating this needs a little work since position, order and name of the fields can change. Using a code I need to find the position of the fields and then rename them, delete...
  2. Y

    Question How to import excel xlsx file to sql with changing header location and name

    How to import data from excel xlsx files to sql database if in some files the row and content of the headers are changing (even if they change they point the same data, see example)? I work in Visual basic environment with VS 2012 Here is the example: The problem is number of headers are...
Top Bottom