Importing data into SQL database
Quote from m.burdess on July 26, 2021, 5:29 pmCan anyone tell me the best way to import CSV data into the sql database that I have created. I have tried SQLite Browser with VisualNeo Web, but this just stops responding. The CSV file has just under one million line and seven columns.
Can anyone tell me the best way to import CSV data into the sql database that I have created. I have tried SQLite Browser with VisualNeo Web, but this just stops responding. The CSV file has just under one million line and seven columns.
Quote from luishp on July 27, 2021, 9:09 amHi @m-burdess there are many options. I would try:
Online solution (nothing to install):
https://anyconv.com/es/convertidor-de-csv-a-sqlite/Using the last SQLite Browser version (free software):
https://sqlitebrowser.org/Let me know if you have success.
Best regards.
Hi @m-burdess there are many options. I would try:
Online solution (nothing to install):
https://anyconv.com/es/convertidor-de-csv-a-sqlite/
Using the last SQLite Browser version (free software):
https://sqlitebrowser.org/
Let me know if you have success.
Best regards.
Quote from m.burdess on July 27, 2021, 12:20 pm@luishp
Thank you for the help, I found the DB Browser for SQLite-win64. This opens the database but when it save the changes, the database no longer works. It look to use a different layout for the data.
The online solution just comes up with Error each time I try.
The data that I'm trying to load is available from the Government website if that helps.
https://www.gov.uk/government/publications/adult-education-budget-aeb-postcode-files
Thank you for the help, I found the DB Browser for SQLite-win64. This opens the database but when it save the changes, the database no longer works. It look to use a different layout for the data.
The online solution just comes up with Error each time I try.
The data that I'm trying to load is available from the Government website if that helps.
https://www.gov.uk/government/publications/adult-education-budget-aeb-postcode-files
Quote from luishp on July 27, 2021, 12:23 pmThank you for the help, I found the DB Browser for SQLite-win64. This opens the database but when it save the changes, the database no longer works. It look to use a different layout for the data.
@m-burdess I think you should check the DataBase fields and customize them to your needs once the data is imported.
Thank you for the help, I found the DB Browser for SQLite-win64. This opens the database but when it save the changes, the database no longer works. It look to use a different layout for the data.
@m-burdess I think you should check the DataBase fields and customize them to your needs once the data is imported.
Quote from m.burdess on July 27, 2021, 1:02 pm@luishp
I have checked the Database and went to customize the imported data, and got;
I have checked the Database and went to customize the imported data, and got;
Uploaded files:
- You need to login to have access to uploads.
Quote from luishp on July 28, 2021, 10:21 am@m-burdess sorry no idea what could be happening.
It's possible the .csv format you are using is not standarized.Perhaps you can try this alternative online option:
https://www.rebasedata.com/convert-csv-to-sqlite-onlineGood luck.
@m-burdess sorry no idea what could be happening.
It's possible the .csv format you are using is not standarized.
Perhaps you can try this alternative online option:
https://www.rebasedata.com/convert-csv-to-sqlite-online
Good luck.
Quote from m.burdess on July 28, 2021, 10:29 am@luishp
Thank you for the help, yesterday I look through the forum, and found the link to the above company and using them to convert the .csv file.
Thank you for the help, yesterday I look through the forum, and found the link to the above company and using them to convert the .csv file.
Quote from m.burdess on July 30, 2021, 5:11 pm@luishp
I have worked with this site and have not yet got a working file. I have even converted the csv file to dbase and it still does not work.
I have worked with this site and have not yet got a working file. I have even converted the csv file to dbase and it still does not work.
Quote from luishp on July 30, 2021, 6:52 pmHi @m-burdess data transformation can be quite tricky sometimes. Wich .csv file exactly are you trying to import to SQLite? I'm quite busy but will try to help you.
Regards
Hi @m-burdess data transformation can be quite tricky sometimes. Wich .csv file exactly are you trying to import to SQLite? I'm quite busy but will try to help you.
Regards
Quote from m.burdess on July 30, 2021, 10:30 pm@luishp
Once again, thank you the help. I have found out that if you use DB Browser for SQLite PortableApp version of 3.7.0 it will work but not with the latest version. But I will see if it works when I finish editing the csv file.
Once again, thank you the help. I have found out that if you use DB Browser for SQLite PortableApp version of 3.7.0 it will work but not with the latest version. But I will see if it works when I finish editing the csv file.