473,287 Members | 1,447 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Help regarding importing data from the excel sheet to mysql

I am able to import data from the database to excel sheet. But i was unable to load the data from the excel sheet to my sql.I have connected the excel sheet to my sql but the data that is imported to the database is corrupted as it is required to enter how the two data are seperated and how does the new line begins. I will b using the visual basic for this purpose. Can i get any sort of help
May 14 '07 #1
7 2421
code green
1,726 Expert 1GB
It is not clear how you are writing to and from the DB. Or if you are doing it programmatically. And by Excel do you mean XLS? MySql has problems with XLS (At least I do).But CSV files are uncorrupted so long as the CSV fields go in the same order as the DB table.
May 14 '07 #2
It is not clear how you are writing to and from the DB. Or if you are doing it programmatically. And by Excel do you mean XLS? MySql has problems with XLS (At least I do).But CSV files are uncorrupted so long as the CSV fields go in the same order as the DB table.
I was trying to take data from the excel sheet to the database. And yes, Excel sheet means .xls. I have done the job if i would have been using .csv format. Actually in .csv format we can specify that how the data and the new line are seperated but in xls i dont know how they both are seperated i.e. the records and the lines. If we can find a way to distinguish them then the job would be done as i have imported the data but was not able to distinguish between the seperators.
anyways i was just looking out for something and came upto some links which i am just about to read.
Try them out.
http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/importing-data-from-excel-sheet-into-sql-435980
http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/
http://support.microsoft.com/default.aspx?scid=kb;en-us;306572
May 15 '07 #3
It is not clear how you are writing to and from the DB. Or if you are doing it programmatically. And by Excel do you mean XLS? MySql has problems with XLS (At least I do).But CSV files are uncorrupted so long as the CSV fields go in the same order as the DB table.
I've found out some s/f'wares. You can use them to connect excel sheet to mqsql. Or you can make sql database by using them.

These are the links:

Some important links regarding connecting excel sheet to mysql

http://www.surfpack.com/software/importexceltomysql/

http://www.surfpack.com/downloads/di...-download.html

http://www.vclcomponents.com

http://www.stardeveloper.com/article...3101901&page=1
May 15 '07 #4
code green
1,726 Expert 1GB
I thought you wanted to write it yourself in VB. These are off the shelf software applications.
May 15 '07 #5
I thought you wanted to write it yourself in VB. These are off the shelf software applications.
I've got some links 2 for writin a program.....


http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/

http://support.microsoft.com/default.aspx?scid=kb;en-us;306572
May 16 '07 #6
code green
1,726 Expert 1GB
Inserting .xls files in to a database has been a problem of mine for a while. I have had to convert them in Excel to a .csv first. Although you started the thread you have pointed me towards a possible solution. If you are going to develop some code I would be very interested
May 16 '07 #7
Inserting .xls files in to a database has been a problem of mine for a while. I have had to convert them in Excel to a .csv first. Although you started the thread you have pointed me towards a possible solution. If you are going to develop some code I would be very interested
i am working on the code and if i can work it out i will def tell u... n thanks a lot for your help.....
May 17 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Dan | last post by:
Hello, I am trying to read and write to an Excel file via my Java applet. I have done so successfully on several simple Excel files that simply had data cells without many complicated equations...
9
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then...
2
by: Mr. Bungle | last post by:
When importing excel from access I am fully aware that one can import directly into a table. Can you get as specific via code or something to import data from an excel sheet to a FORM (Not Table)...
9
by: jillandgordon | last post by:
I am trying to import an excel file into Access 97. It looks perfectly all right but, every time I try to import it, I get to the lst step and am told that it was not imported due to an error. ...
3
by: Conrad F | last post by:
Hello All, I know how to import a specific named excel sheet into a datagrid using ADO.NET by setting up a JET connection and then SELECTing data from the sheet. However, for a real world...
11
by: DrewKull | last post by:
Ok ... so i have a database im building to track user feedback. The problem im running into is we need to track "Problems" detected in the feedback, but we have multiple inputs for feedback. So...
8
by: hyper-sensitive | last post by:
Hi Can some body suggest me which approach I should follow to import millions of records from data base into an excel sheet? I am working with ver. 2000 of MS-Excel . The requirement is to...
1
by: zamzoum | last post by:
hi i just wanted to ask u how can i solve the exception error "couldnot find installable ISAM" this exception occurs when i run this code : Dim excelConnection As...
4
by: alvinstraight38 | last post by:
Hey guys, I am trying to import data from an Excel spreadsheet into my SQL database. I am running SQL 2005. I following Microsoft's instructions for creating a linked server, and it appeared...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.