title: Excel to sql, using delimiter (;) - postgres/pgadmin
body: <p>I am trying to import an excel file to postgresql using pgadmin but faced many issues here.</p>
  
  <p>My original data is an excel format and the data values include many comma. So I convert excel file into csv format using delimiter (;). I could do so by unchecking  "use system separators" option in excel. (This will make changes in numeric values. For example, 40.2 becomes 40,2)</p>
  
  <p>When I try to import this csv file in pgadmin I got numerous errors due to data type, numeric. The pgadmin do not consider 40,2 as a numeric value. Interestingly, I could do similar thing with other dataset when I convert the other data set (txt -> csv (;)-> then import to pgadmin). It worked!
  However, if I try with my data it did not work.
   (excel -> txt -> csv (;) -XX-> pgadmin).</p>
  
  <p>Any idea how I can address this? Maybe I would like to know other ways to generate semicolon-csv files from excel.</p>