General discussion

Locked

Need database import tools

By chrisi ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Need database import tools

by mshavrov In reply to Need database import tool ...

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.

Collapse -

Need database import tools

by chrisi In reply to Need database import tool ...

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

Collapse -

Need database import tools

by M.A. Durkee In reply to Need database import tool ...

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,

Collapse -

Need database import tools

by chrisi In reply to Need database import tool ...

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.

Collapse -

Need database import tools

by chrisi In reply to Need database import tool ...

This question was closed by the author

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums