473,324 Members | 2,178 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,324 software developers and data experts.

Automate Copying Fields

Hello,

Our company has an ecommerce website and we also sell on eBay. We are looking for a way to automate listing products on eBay that are already on our website and keeping pricing and inventory consistent.

We have two Excel files that have been converted into tables in an Access 2003 database. One is the inventory of our products on our website and the other table contains the required fields to import into eBay. Many of the fields in each table contain the same information about each product but the field names are different, e.g. Product SKU and Product Number. We are looking for the most efficient way to automate coping over these fields as we have several thousand products.

Is this something that can be done with simple macros or would modules with VBA code be required?
Nov 28 '11 #1
6 1694
Mihail
759 512MB
Hi Rob !
Welcome to the forum !

Sorry, but to convert the Excel sheets into tables is one thing and to obtain a database from this tables is a total different thing.

I think that is better to do the job in Excel (maybe because I know better Excel than Access) then convert into table(s).

On the other hand, what you wish to copy ? And what you wish to obtain ? A new set of records ? An updated table using records from the second one ?

Come back with a fully set of information about what you wish to do.
Nov 28 '11 #2
NeoPa
32,556 Expert Mod 16PB
In Access simply set up a query of the table and assign ALIASes to the fields with different names from the ones required.

EG.
Fields required by eCommerce site :
ProductName
SellPrice
Colour

Fields required by eBay :
ProductName
SalePrice
ProdColour

Table Name = [tblWeb]
Expand|Select|Wrap|Line Numbers
  1. Field Name     Type
  2. ProductName    String
  3. SellPrice      Currency
  4. Colour         String
Query Name = [qryeBay]
Expand|Select|Wrap|Line Numbers
  1. SELECT [ProductName]
  2.      , [SalePrice] AS [SellPrice]
  3.      , [Colour] AS [ProdColour]
  4. FROM   [tblWeb]
Such ALIASing can also be handled in Design View of a query by using :
Expand|Select|Wrap|Line Numbers
  1. SellPrice: [SalePrice]
  2. ProdColour: [Colour]
Nov 28 '11 #3
Please allow me to clarify.

The table downloaded from our website is actually a "linked" table. This way, we can download the file each day and simply upload the link to the Access database. The second table was created in Access and contains all the fields required by eBay when uploading our products for posting on eBay. The tables are both joined by the Product SKU.

At this point, I am thinking we need some sort of Macro or code to open both files, and copy the contents of the required fields from our website table to the eBay table. What about a command like For Each Record, copy these fields to this Table?
Nov 28 '11 #4
NeoPa
32,556 Expert Mod 16PB
Of course you're allowed to clarify at any time, but we prefer you do so in the original question. It doesn't seem too onerous a requirement and can save much wasted time. Unfortunately, it seems clarity is still some way off.

Is one of the tables a master or something, such that you'd overwrite details of one table with the other? How about some details so that we have something to work from.
Nov 28 '11 #5
The eBay table is really just a blank table with the required field names that are needed for a successful upload of our products. Some of the fields for each record will always be the same. For example, the field PayPalAccepted is a yes/no value that will always be "yes".

So again, we're looking for an automated solution in which Access can look at values for certain fields and copy them from the linked table to the eBay table. Then we save or export the eBay table and we're good to go. Or, we could do the same with a query.

I posted my clarification above responding to Mihail and prior to reading your suggestion, NeoPa, about the ALIAS field names in a query. This might work since a lot of the fields have the same values but the field names are different. As long as the final output uses the ALIAS field names.

Thank you for your help.
Nov 28 '11 #6
NeoPa
32,556 Expert Mod 16PB
Ah. I see. That certainly makes more sense if considered in that context :-)

Yes. The final output would use the ALIAS names.
Nov 28 '11 #7

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

Similar topics

5
by: Ian Davies | last post by:
Hello I am trying to use php to automate the copying of a file from my remotely hosted directory to my computer. I have put together the following but it will only do the copying from one...
3
by: radioman | last post by:
Hi all, I would appreciate some help please. I just need pointing in the right direction as I am at a loss. Basically I have a form (frmAddMaster) which displays two subforms "Master Stock...
3
by: sparks | last post by:
I was copying fields from one table to another. IF the var name starts with milk I change it to egg and create it in the destination table. It works fine but I want to copy the description as...
1
by: Jimbo | last post by:
Hi Guys, I'm hoping one of you will give me a leg up with a problem Im having, which I think is possible to do. Let me explain. I have 2 tables and 1 form - ie 'tableDigit', 'tableNumber' and...
0
by: deko | last post by:
I looking for way to reliably automate the process of upgrading users to a new version of an Access MDE application. I've tried this code a few times and it seems to work (gets custom menubars,...
3
by: John Marble | last post by:
I have around 400 excel files filled with data that I need to import in ACCESS. The tricky part is that they must be imported one at time, and properly corrected before importing the next one. I...
1
by: Liam.M | last post by:
I currently HAVE a form...a "Summary List" it could be called...which is a contineous form...AND on this form are "Four fields" from EVERY record (each on their own line) so to seak...like a...
10
by: Killer42 | last post by:
Hi all. If necessary I'll repost this in the Windows forum, but I thought this would be a good place to hit a fair cross-section of the community. Besides, anyone can see that all the best brains...
16
by: pmatzek | last post by:
I am attempting to automate a process involving importing a .txt file into an existing table, changing a date in each record, then exporting the table, again as a .txt file. One field contains a...
0
by: shrey shiwam | last post by:
there are numerous lines of entries in a notepad. I want to take each line and put into a separate row of an xls sheet. can i automate this process. plz help me on this.
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.