There is probably an easy answer to this but...

I've been working on a database fr a while now, its for a low use online shop, I've got about 2600 records in an access mdb I use to get the info from, I have a primary Key set to the products sku and obviously a field that is the sell price, I've been trying to work out how to import a complete price update from an exl or another mdb which has only the sku and new price but I'm unable to do so.

I basically need to import all the info from the new file, match it to the data in the main table and then update the prices. How is best to go about this?

I'd like to also update a "discontinued" field if the price I added in was 0 for example. But this isnt essential as I can do that in the webpage code.

Thanks for any help and sorry for the bad english, its late after another night of failed attempts to get it to work.

Sep 20 '06 #1

Subscribe Post Reply

1291

tpawleska

It's easy to import the items just right click in the table area and go to import, but then you will need to select what tabel you want to import, if your access database is setup correctly this shoudl be easy if not, then you may need to alter either your database or your excell table to match up the tabs in excell with the tables in access.

I've been working on a database fr a while now, its for a low use online shop, I've got about 2600 records in an access mdb I use to get the info from, I have a primary Key set to the products sku and obviously a field that is the sell price, I've been trying to work out how to import a complete price update from an exl or another mdb which has only the sku and new price but I'm unable to do so.

I basically need to import all the info from the new file, match it to the data in the main table and then update the prices. How is best to go about this?

I'd like to also update a "discontinued" field if the price I added in was 0 for example. But this isnt essential as I can do that in the webpage code.

Thanks for any help and sorry for the bad english, its late after another night of failed attempts to get it to work.

Sep 20 '06 #2

by: malcolm | last post by:

How does one get the primary key of the row that is joined in via a group by aggregate clause when the aggregate is not performed on the primary key? For example, Person table ( PersonID...

Microsoft SQL Server

Is there an "easy" way to get the hardware parts temperature?

by: ThunderMusic | last post by:

Hi, Is there an "easy" (I mean, with .NET framework and no asm code) to get the hardware parts temperature assuming there are sensors to sense it? Like the CPU Core temp or any other parts. I know...

.NET Framework

Would there be support for a more general cmp/__cmp__

by: Antoon Pardon | last post by:

I was wondering how people would feel if the cmp function and the __cmp__ method would be a bit more generalised. The problem now is that the cmp protocol has no way to indicate two objects are...

Python

Is there a way to have the style sheet included in the sqame file as the XML data

by: RD | last post by:

My app transmits XML data file via e-mail and for now I attach both the XML data file and the corresponding style sheet. I found however that whenthe recipient double clicks on the XML file to read...

.NET Framework

VBA Question: Is There an Easy Way to Trim All Fields in a Table?

by: No Spam | last post by:

Dear fellow Access 2003 Users, Is there a way to trim all of the fields in a table in one swoop using VBA (preferred) or a query? Right now, I am using an update query and updating EACH field...

Microsoft Access / VBA

Is there a Serializable Sorted List in .NET?

by: Charles Law | last post by:

I want to sort a collection of objects, which has been read from an XML file. I also wish to be able to access the elements of my collection by key or index. Is there such a collection already...

Visual Basic .NET

Is there an easy way to copies all files in a directory into another directory?

by: **Developer** | last post by:

Is there an easy way to copies all files in a directory into another directory? What about coping subdirectories too? Thanks in advance for any info

Visual Basic .NET

how to parse an executable in C and find out if there is any return(RET in assembly) or not

by: priyanka | last post by:

Hi, I was wondering if we could parse or do something in the executable( whose source language was C). How can I use some scripting language like perl/python to find out the information about...

C / C++

Is there an obvious way to do this in python?

by: H J van Rooyen | last post by:

Hi, I want to write a small system that is transaction based. I want to split the GUI front end data entry away from the file handling and record keeping. Now it seems almost trivially easy...

Python

Why is there no GUI-tools like this for Windows?

by: maestro | last post by:

http://www.youtube.com/watch?v=PXpwC1o5AcI I have done some GUI-programming for windows with Python but the Tkinter interface sucked and while it is the only one I tried I got the impression...

Python

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

There is probably an easy answer to this but...

Similar topics