ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Conversion into Sybase (https://www.excelbanter.com/excel-discussion-misc-queries/2032-data-conversion-into-sybase.html)

jagluski

Data Conversion into Sybase
 
Hello. We have a very large Excel spreadsheet that we want to convert into a
Sybase Database. We are wondering if anyone had a good suggestion as to go
about doing this. We've thought about converting the data into MS Access
first and then going to Sybase, but using the intermediate program doesn't
seem like it is the best idea.

Also, we're only converting about 1000 rows now, but there are many, many
more that will need to be converted later on.

Any sugggestions would be appreciated. Thanks.

Frank Kabel

Hi
I would try to save the Excel files as *.csv file. Sybase should be able to<
open this (to import it)

--
Regards
Frank Kabel
Frankfurt, Germany
"jagluski" schrieb im Newsbeitrag
...
Hello. We have a very large Excel spreadsheet that we want to convert
into a
Sybase Database. We are wondering if anyone had a good suggestion as to
go
about doing this. We've thought about converting the data into MS Access
first and then going to Sybase, but using the intermediate program doesn't
seem like it is the best idea.

Also, we're only converting about 1000 rows now, but there are many, many
more that will need to be converted later on.

Any sugggestions would be appreciated. Thanks.





All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com