pinoyz

Hi!

I'm creating an Inventory System which you can see all kinds of products....

i know how to add, delete or change using sqlcommands...... but my problem is how can i import the data came from excel or text files (large amount of DATA) and placed that data into database (with your own program)... it's like an open a file, then click import data to database...

like that.... how can we do that




Re: Visual Basic Express Edition Importing Data(excel/ text) and save to Database.....using your own program...HOW?

pinoyz

bump




Re: Visual Basic Express Edition Importing Data(excel/ text) and save to Database.....using your own program...HOW?

Bruno Yu - MSFT

pinoyz,

According to your description, I would like to recommend you to show us the type of the database you use. From your SqlCommand class, I know that you are using SQL Server database.

Here are two articles that on your demand. Please take a look at the articles and I hope these can help you:

1. How to import data from Excel to SQL Server

http://support.microsoft.com/kb/321686/

2. How to import data from Microsoft SQL Server into Microsoft Excel

http://support.microsoft.com/kb/306125/