Desktop

Ask something
Discussion Locked

Need database import tools

0 helpful
5 replies

by chrisi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am a traditional power end-user that also has been blessed with systems administration and data conversion for a new app. Our new app uses the Borland Database Engine, and SQL compatable tables.

What tools are available so that I can populate data fields from flat files, Excel spreadsheets, or Access tables into the db tables?

I have a lot of one to one record data from external sources that needs to be added. I am learning SQL as we speak, but I am still not sure how to take all thisdata and import it.

I have used flat file imports and exports to move data off of and onto a HP3000 before, as well as an AS/400. However, I have no experience with a
decent sized RDB, and my Access skill are weak.

I appreciate any suggestions.

5 replies

by mshavrov

Microsoft SQL Server Import Wizard. It allowes to import many formats to many formats and even perform some calculations and conversations during import. Especially it's good since you will have SQL compatible databases.

Good luck.

by chrisi

Thanks for your answer. However, we will not be using a MS SQL database, so, it would be hard to use those tools.

by m.a. durkee

If you are using T-SQL(MS SQL) - Data Transformation Services(DTS) should be one of the tools included and should more or less get your data imported successfully.
If you are using MS SQL 2000, then you can actually start using data pumps to automated the import process.

Check out this link for more SQL info and open source snippets:

http://www.developersdex.com/sql/Default.asp

Regards,

by chrisi

Thank you! Unfortunately, I will be using Sybase SQL. I will see if it has such tools. I doubt it, based on the software source from the application developer. I appreciate the suggestion.

This discussion is closed to new replies.