Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-24-2008, 08:55 AM   #1
Yecats131
Registered User
 
Join Date: Apr 2008
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Yecats131 is on a distinguished road
Exclamation A import problem that I need to tackle

Hello!

So, I'm currently teaching myself Access as I go along. I have basic VB knowledge as well. The problem that I need to tackle is the following:

I have a table that contains several fields... The 3 that have to deal with this are: Req#, Status, and Status date.

Req number: primary Key
Status: Will Change
status date: Will Change

So, I have a spread sheet from another program that is ran once a week that contains the req# and new status information for those particular requisitions. Rather then going into the table one by one and changing the status and date myself... I want to know if there is a way to set it up to have the spreadsheet with the new information imported into access and automatically change the status information over.


Please let me know if I'm not making any sense... :0)

Thanks!

Yecats131 is offline   Reply With Quote
Old 04-24-2008, 09:53 AM   #2
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
Import the spreadsheet then run an update query to update the status and date.
__________________
If my post has helped you solve your problems please add to my reputation. Click the scale in the top right side of this post.
KeithG is offline   Reply With Quote
Old 04-24-2008, 10:21 AM   #3
Yecats131
Registered User
 
Join Date: Apr 2008
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Yecats131 is on a distinguished road
In noob speak please

Yecats131 is offline   Reply With Quote
Old 04-24-2008, 02:31 PM   #4
Villarreal68
Newly Registered User
 
Villarreal68's Avatar
 
Join Date: Feb 2007
Posts: 133
Thanks: 5
Thanked 0 Times in 0 Posts
Villarreal68 is on a distinguished road
This is the best I an offer! Sorry!

How to link to an Excel Workbook: http://office.microsoft.com/en-us/ac...CH101759701033

How Update Queries work: http://office.microsoft.com/en-us/ac...CH100645771033

Hope this helps!
Villarreal68 is offline   Reply With Quote
Old 04-24-2008, 04:23 PM   #5
Yecats131
Registered User
 
Join Date: Apr 2008
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Yecats131 is on a distinguished road
Talking

Actually... this helps a lot.

Thank you
Yecats131 is offline   Reply With Quote
Old 04-25-2008, 08:14 AM   #6
Yecats131
Registered User
 
Join Date: Apr 2008
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Yecats131 is on a distinguished road
Okay, so I've ready over the tutorials and Help sites that were provided to me. It looks like a Update Quary only allows you to update information built in.... which doesn't help.

(Replace ___ with ____ if x condition is met)

What I have is a spreadsheet with a list of requisition numbers who's status information needs to be updated.

When I import an excel spreadsheet directly, does it locate the Primary Key (Requisition number) and update the information accordingly?
Yecats131 is offline   Reply With Quote
Old 04-25-2008, 09:28 AM   #7
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
What do you mean by built in? An update query will update infomation in a field.

__________________
If my post has helped you solve your problems please add to my reputation. Click the scale in the top right side of this post.
KeithG is offline   Reply With Quote
Old 04-25-2008, 09:46 AM   #8
G37Sam
Car Geek
 
G37Sam's Avatar
 
Join Date: Apr 2008
Location: Dubai, UAE
Posts: 428
Thanks: 13
Thanked 51 Times in 49 Posts
G37Sam is on a distinguished road
Hello,

you can use the Docmd.transferspreadsheet method, this will transfer contents of a spreadsheet into a table, you can then use a query to update whatever data you need from another table

regards,
Samer
G37Sam is offline   Reply With Quote
Old 04-25-2008, 09:57 AM   #9
odin1701
Newly Registered User
 
Join Date: Dec 2006
Posts: 526
Thanks: 1
Thanked 3 Times in 3 Posts
odin1701 is on a distinguished road
Quote:
Originally Posted by Yecats131 View Post
Okay, so I've ready over the tutorials and Help sites that were provided to me. It looks like a Update Quary only allows you to update information built in.... which doesn't help.

(Replace ___ with ____ if x condition is met)

What I have is a spreadsheet with a list of requisition numbers who's status information needs to be updated.

When I import an excel spreadsheet directly, does it locate the Primary Key (Requisition number) and update the information accordingly?

If you tell it to.

You need to have a condition put on the primary key.

So if it's the Req#, then you just need to have the update query match the Req# from your temporary import table to the main table, then update the status field from the temporary import table.

The query will only change data where the two Req#'s are equal.

odin1701 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MSACCESS Import Date problem tommiy General 1 03-11-2006 06:03 PM
Advance Excel Import Problem shariefoo Forms 0 10-26-2003 09:14 PM
Problem trying to Import decimals Monti2 General 2 12-06-2002 01:31 AM
Import .csv file problem Louise Modules & VBA 3 08-24-2000 02:25 PM
Import and export problem Kenneth Modules & VBA 0 08-23-2000 11:49 PM




All times are GMT -8. The time now is 04:14 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World