All Questions
92 questions
1
vote
1
answer
61
views
Problem with cleaning csv data before Importing in PostgreSQL
I started studying SQL a month ago. I'm trying to import a .CSV file but I have a problem.
In the that file, there are numbers written in quotes and where decimals are divided by commas.
In Excel, if ...
0
votes
1
answer
182
views
How to combine multiple xml files into sql table?
I have 50K xml files (zml technically, but behave the same), each with metadata for a single file. I need to combine that metadata into a single SQL table so I can manipulate it there. The xml files ...
- 25
0
votes
1
answer
67
views
How to make a table containing history of imported excel files
I have watched videos on youtube on how to import excel data to my table and made it work on my code. But my problem is I want to show history of imported excel files using another table.
This is what ...
- 45
1
vote
0
answers
273
views
Adding a query to SQL Server Import and Export Wizard
I am wanting to update the inv_mast table with an excel spreadsheet. I was able to successfully do this by importing the data as a table and then running the query afterwards and then dropping the ...
- 53
1
vote
0
answers
237
views
SQL: Import and Export Data Wizard 64bit not showing Excel workbook option
I'm using a 64bit computer and I'm trying to upload an excel file to the database with the "Import and Export Data Wizard" 64bit but no Excel workbook option. Someone can help me please?
- 27
0
votes
1
answer
4k
views
"ERROR: unterminated csv quoted field" in Postgresql import from Excel - large files only
I have exported files of the same format of varying sizes from a database > Excel > save to CSV, and attempted to import them into my database using PgAdmin 4.
The tables are all created, no ...
0
votes
1
answer
36
views
Easiest way to import excel dataset into preexisting SQL table? [closed]
I have a table that has FY17-FY19 data, I want to append FY20 data. What would be the easiest way to accurately do this? I don't want to have to recreate a new table.
- 1
0
votes
0
answers
51
views
Try to import csv file to SQL, error saying that index list out of range? How to fix it?
I try to import excel data to sql. but error said that index list out of range? How to fix it?
- 1
0
votes
0
answers
352
views
Insert date values into SQL datetime column from excel
I am trying to insert data from excel to a SQL table.
When I try to insert date values into the datetime column the values are being taken as null.
Can anyone help here.
1
vote
6
answers
8k
views
How to import (Copy/Paste) data from Excel table to SQL query/client [duplicate]
How to import (Copy/Paste) data from Excel table to SQL query/client?
NB!:
Without using OPENROWSET
Without using online converters
- 791
0
votes
0
answers
601
views
Excel VBA - importing data from another workbook in different directory via sql query (No Open.file method)
I am not able to gather data from an external workbook and copy it. I can do it in the same workbook; but I cannot write down the path or something missing. The problem may be related with the shRead()...
- 1
1
vote
0
answers
35
views
The indicated ColumnName 'Data_Mov' does not match any column data source
Trying to import some excel data to sql database, and they have different column names, cause the excel file has special characters and etc...
and I have always this error...
Here's the code:
{
...
user11442425
0
votes
0
answers
34
views
Importing Multiple Excel Tables Inside a Worksheet to SQL
I am trying to import multiple tables that are in the same Excel worksheet into separate SQL tables. The problem is that these tables are just separated by format (margins and blank spaces between ...
0
votes
0
answers
36
views
excel SQL insert
I am creating an excel spreadsheet that imports a list of Service Desk Analyst Names into Excel from SQL in column A.
Columns B, C, D, etc contain the User IDs for the companies and applications they ...
- 1
1
vote
2
answers
2k
views
Import from Excel to SQL with conditional check for duplicates
I have a huge number of data stored in PDF files which I would like to convert into a SQL database. I can extract the tables from the PDF files with some online tools. I also know how to import this ...
- 11