I have an Excel file of 1362 rows and 30 columns. I need to load it
into my database to update addresses and phone numbers. Each record
has its own ID number, which is defined in the Excel file and in the
database. The database is Millenium Version 7.2.1.1. I can't really
find any signifigance between any of the records. Is there a way I can
just load them into my database and update each record? Maybe by using
the ID number?
Dane Winkler
Database Specialist
St Vincent College da**********@email.stvincent.edu 4  2757 
In article <eb**************************@posting.google.com >, dawinx25
@hotmail.com says... I have an Excel file of 1362 rows and 30 columns. I need to load it
into my database to update addresses and phone numbers. Each record
has its own ID number, which is defined in the Excel file and in the
database. The database is Millenium Version 7.2.1.1.
I'm sorry, Dane, I missed something. Where does MS-SqlServer enter the
picture?
--
Who's better for furniture? NOOOOOOOOOOOOOOOOOOBODY!!!!
Guinness Mann GM***@Dublin.com
Guinness Mann <GM***@dublin.com> wrote in message news:<MP************************@news.newsguy.com> ... In article <eb**************************@posting.google.com >, dawinx25
@hotmail.com says... I have an Excel file of 1362 rows and 30 columns. I need to load it
into my database to update addresses and phone numbers. Each record
has its own ID number, which is defined in the Excel file and in the
database. The database is Millenium Version 7.2.1.1.
I'm sorry, Dane, I missed something. Where does MS-SqlServer enter the
picture?
Well, my database is SQL platform. I think it can be done through Data
Transformation, but I'm not sure.
In article <eb**************************@posting.google.com >, dawinx25
@hotmail.com says... Guinness Mann <GM***@dublin.com> wrote in message news:<MP************************@news.newsguy.com> ... In article <eb**************************@posting.google.com >, dawinx25
@hotmail.com says... I have an Excel file of 1362 rows and 30 columns. I need to load it
into my database to update addresses and phone numbers. Each record
has its own ID number, which is defined in the Excel file and in the
database. The database is Millenium Version 7.2.1.1.
I'm sorry, Dane, I missed something. Where does MS-SqlServer enter the
picture?
Well, my database is SQL platform. I think it can be done through Data
Transformation, but I'm not sure.
Which version of Microsoft SQL Server is it, Dane? Microsoft SQL Server
2000? Microsoft SQL Server 6.5? It makes a difference.
Guinness Mann <GM***@dublin.com> wrote in message news:<MP************************@news.newsguy.com> ... In article <eb**************************@posting.google.com >, dawinx25
@hotmail.com says... Guinness Mann <GM***@dublin.com> wrote in message news:<MP************************@news.newsguy.com> ... In article <eb**************************@posting.google.com >, dawinx25
@hotmail.com says...
> I have an Excel file of 1362 rows and 30 columns. I need to load it
> into my database to update addresses and phone numbers. Each record
> has its own ID number, which is defined in the Excel file and in the
> database. The database is Millenium Version 7.2.1.1.
I'm sorry, Dane, I missed something. Where does MS-SqlServer enter the
picture?
Well, my database is SQL platform. I think it can be done through Data
Transformation, but I'm not sure.
Which version of Microsoft SQL Server is it, Dane? Microsoft SQL Server
2000? Microsoft SQL Server 6.5? It makes a difference.
It's 7.0 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Hennie de Nooijer |
last post by:
Hi,
Currently we're a building a metadatadriven datawarehouse in SQL
Server 2000. We're investigating the possibility of the updating
tables with enormeous number of updates and insert and the...
|
by: Chris Jackson |
last post by:
I'm a novice Access user and am not sure how to solve the following problem.
Any help with the following would be greatly appreciated!
I have two tables with identical structures, the first holds...
|
by: |
last post by:
I am updating MS access tables with data in an xml
document. I create two dataset, one for existing data and
one for new data. I fill the first dataset with the
records from MS Access, the second...
|
by: P |
last post by:
Hello,
I am having a difficult time updating a record via a stored procedure using
the gridview and sqldatasource. I cannot seem to be able to find a way to set
everything up so that I can pass...
|
by: Darrel |
last post by:
I'm creating a table that contains multiple records pulled out of the
database. I'm building the table myself and passing it to the page since the
table needs to be fairly customized (ie, a...
|
by: davidgordon |
last post by:
Hi,
If I am updating a list of records for a user on an asp page, is there
a way to hold the page updating, even if they refresh the page, until I
have updated all the records.
i.e. rather...
|
by: Jeff |
last post by:
For years I have been using VBA extensively for updating data to tables
after processing. By this I mean if I had to do some intensive processing
that resulted in data in temp tables, I would have...
|
by: Alexey.Murin |
last post by:
The application we are developing uses MS Access 2003 database (with
help of ADO).
We have noticed that during massive records updating the size of the
mdb file increases dramatically (from 3-4 to...
|
by: chimambo |
last post by:
Hi All,
I have a little problem. I am retrieving records from a table and I
want to update the records using checkboxes. I am able to display the
database record quite alright and I have created...
|
by: Bill Schanks |
last post by:
I have a winform app (VB 2005) that allows users to export data to
excel, make updates to the excel file and import the data from that
Excel file and update the database.
My question is: Is it...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
