通过excel函数将CSV转换为oracle表 [英] CSV to oracle table by excel function

问题描述

我有一个MSSQL日期维度表。我将表解压缩为CSV文件，需要将其移动到我们创建的新Oracle表中。问题是我们无权访问Oracle服务器，因为它由另一家公司远程托管，我们只是发送文件来创建并将单元格插入表中。 CSV文件大约为18mbs，包含数据。我一直在使用Excel来连接值，但是Excel一直在更改我的CSV值格式，如果没有长度TEXT字符串，这些字符串需要很长时间才能完成我的数据量。我也尝试了 CSV转SQL转换器 [ ^ ]。他们只是锁定了复制/粘贴/文件大小的大小。是否有任何方法可以轻松地为Oracle创建插入函数，因为通过Excel的方式非常非常耗时，并且在一行中至少有2500个字符，甚至可能不会显示在单个单元格中。



我尝试了什么：



试过在线转换器，试过excel连接

I have a MSSQL date dimensions table. I extracted the table as a CSV file and need to move it to a new Oracle table we have created. The problem is that we don't have access to the Oracle server as it is hosted remotely by another company and we just send them the file to create and insert cells into the table. The CSV file is roughly 18mbs large with the data is contains. I have been using Excel to CONCATENATE the values but Excel has been changing my CSV value formats and doesn't work without length TEXT strings that would take a long time to complete for the amount of data I have. I have also tried sites like CSV To SQL Converter[^] . They just lock up with how much big the copy/paste/file-size is. Are there any ways for make the insert functions for Oracle easily because the way through Excel is VERY time consuming and will be at least 2500 characters long in one line which may not even show in the single cell.

What I have tried:

Tried online converters, tried excel concatenate

推荐答案

sql - Oracle批量导入 - 堆栈溢出 [ ^ ]

这篇关于通过excel函数将CSV转换为oracle表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！