Thanks for another great video Joey. I appreciate you taking the time to go through various errors (e.g. bulk data conversion error related to the column headings in the csv file). Going through the error and the resolution makes the video much more applicable to real world scenarios.
The Bulk Insert statement only allows Inserts. A strategy you could apply is to do a Bulk Insert into a temporary table, then do a Insert Select or Merge into the destination table.
When i executing BULK insert I run into below error: Cannot bulk load because the file "C:\Demo\file.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.). I'm running the SQL server on local server. The file being exported has full permission. I was unable to crack this error. Can you help me and share your thoughts.
I think Imp/Exp wizard is more convenient than bulk insert as it allows us to create & insert into table in one shot. It can be used to insert data from table A to table B by writing a query. Also, it accepts xlsx files directly. No need to convert into CSV & all.
Hi, i have a Question about the Column (Product_Cost) conversion in the Spreadsheet? I mean, you've changed the value 1,999 to 1999? After the Bulk Insert, the value in your table equals 1999.00 ?!? Thoses are two different values, right? Thanks for the video and kind regards
Hi, maybe you can help me. I get the error message. Cannot bulk load because the file "\\File01\.....\TextFile1.txt" could not be opened. Operating system error code 5(Access is denied.).
I try this but I'm getting the following error "Cannot bulk load because the file "file.csv" could not be opened. Operating system error code 67(error not found).". What could it be?
For a moment there I though you were going to find a code work around for inserting those fields with the commas in them like so "9,00". I really need to find a method as I cannot change the .csv file any ideas how I can do this?
If you are using Bulk Insert, you will want to insert them with the comma into a varchar field and have a secondary process (stored procedure) that cleans the column and moves the data to a type correct column. If you are just using SSIS, you can clean it on the way in.
BULK INSERT requires a flat text file, like a CSV, or a Fixed Width, or a Tab Delimited file. The Import/Export Wizard uses different drivers that will allow you to import Excel Files in there XLS format. You could use Import/Export wizard with the CSV file if you wanted to and it would work just fine.
Thanks for another great video Joey. I appreciate you taking the time to go through various errors (e.g. bulk data conversion error related to the column headings in the csv file). Going through the error and the resolution makes the video much more applicable to real world scenarios.
The Bulk Insert statement only allows Inserts. A strategy you could apply is to do a Bulk Insert into a temporary table, then do a Insert Select or Merge into the destination table.
When i executing BULK insert I run into below error:
Cannot bulk load because the file "C:\Demo\file.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).
I'm running the SQL server on local server. The file being exported has full permission.
I was unable to crack this error. Can you help me and share your thoughts.
Love you bro you are a saviour👍👍👍👍
I think Imp/Exp wizard is more convenient than bulk insert as it allows us to create & insert into table in one shot. It can be used to insert data from table A to table B by writing a query. Also, it accepts xlsx files directly. No need to convert into CSV & all.
Amazing,, 👍
Thank you so much or Sharing
Hi, i have a Question about the Column (Product_Cost) conversion in the Spreadsheet?
I mean, you've changed the value 1,999 to 1999? After the Bulk Insert, the value in your table equals 1999.00 ?!? Thoses are two different values, right? Thanks for the video and kind regards
Hi, maybe you can help me. I get the error message.
Cannot bulk load because the file "\\File01\.....\TextFile1.txt" could not be opened. Operating system error code 5(Access is denied.).
is it necessary to create column name before inserting data ????
Hi,
can i update the table or is only an insert possible?
How do I create a text file with comma separate from files in folder and how do I bulk insert text file?
I try this but I'm getting the following error "Cannot bulk load because the file "file.csv" could not be opened. Operating system error code 67(error not found).". What could it be?
For a moment there I though you were going to find a code work around for inserting those fields with the commas in them like so "9,00". I really need to find a method as I cannot change the .csv file any ideas how I can do this?
If you are using Bulk Insert, you will want to insert them with the comma into a varchar field and have a secondary process (stored procedure) that cleans the column and moves the data to a type correct column.
If you are just using SSIS, you can clean it on the way in.
How about insert from multiple flat files?
Why not use SSIS for a bulk load?
I noticed that you did not convert the excel file into a .csv format when you used the IMPORT/EXPORT wizard but you did that for BULK INSERT. Why?
BULK INSERT requires a flat text file, like a CSV, or a Fixed Width, or a Tab Delimited file. The Import/Export Wizard uses different drivers that will allow you to import Excel Files in there XLS format. You could use Import/Export wizard with the CSV file if you wanted to and it would work just fine.
How to BULK Insert in dbeaver? Pls help
Great...thanks man
Does the file have to be in C:\?
Not exactly, Any Drive....
❤❤❤❤🎉