by: jimserac |
last post by:
I had previously posted this in an Access forum
with negative results so will try here.
Although this question specifies an Access database,
I also wish to accomplish this with a large MS SQL...
|
by: jimserac |
last post by:
The following SQL statement, used in VBScript,
will COPY a table from Excel to an Access mdb.
SQL = "SELECT * INTO C1R0" & _
" FROM IN ''" & _
" 'Excel...
|
by: wildbill |
last post by:
I have an Excel spreadsheet with 1000+ rows that I need to import into
an Access 2002 db once a month or so. I then need to use that
information to update any existing records(multiple fields may...
|
by: Chris Fink |
last post by:
Any idea why the database table is not being updated with the contents of the excel file loaded into the dataset? Any help is appreciated!
// load database table, shell only
string cnString =...
|
by: Muskito |
last post by:
HELP!!!
Hello All,
I'm using VB.net 2003 and trying to update data in Excel worksheet.
The program selects data from the excel, updates something in the MSSQL
DB and then tries to update...
|
by: berndh |
last post by:
Hi,
I have a need to update all price fields in an SQL database. The new prices are in an excel spreadsheet (c:\db\update.xls).
Unfortunately the structure of the Excel file is not the same as...
|
by: garry.oxnard |
last post by:
Can anyone help me to solve a problem which involves switching from
Access to Excel (then back to Access) programatically please?
I have an Excel template which, on open, also opens an Access...
|
by: roger.rigsby |
last post by:
Ok I know how to get the data I want from mysql but I need to actually
do something with this data and then send it back to mySQL.
Company heads love the spreadsheet view so this is serious...
|
by: semijoyful |
last post by:
OS: Win XP SP2
Access version: 2003
Excel version: 2003
I am new at this, as I am sure you have gathered from this post title:)
I am working on a form where users can input data in Access and...
|
by: Master Ken |
last post by:
Hi All,
I'm very new to C# and ASP and I am asking for some help as I don't really know where to start on this project.
Some background info first
I run a report each week which outputs data...
|
by: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: Matthew3360 |
last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function.
Here is my code.
header("Location:".$urlback);
Is this the right layout the...
|
by: Matthew3360 |
last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
|
by: WisdomUfot |
last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
|
by: Matthew3360 |
last post by:
Hi,
I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
|
by: Carina712 |
last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
|
