How do you map / arrange 2 Excel flat files
Closed
GrievousAngel
-
Oct 24, 2009 at 11:37 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 11, 2009 at 06:34 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 11, 2009 at 06:34 PM
Related:
- How do you map / arrange 2 Excel flat files
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Gt6 map - Guide
4 responses
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Oct 24, 2009 at 03:38 PM
Oct 24, 2009 at 03:38 PM
what is the source of the data?
you can 'import' your data into excel if the data is in csv format. that is that the data is seperated by a coma. excel sees each coma as a signal to add the data to the next field.
for example:
name, address, postcode,telephone no
excel would import this and create the fields with the above data and add the data to each field.
each record needs to be on a new line.
For access, you can import an excel file into access in the same manner and it will create the tables for you.
to help you further, please explain how you are gathering your ebay data, and how is the data stored in your web site. the website should explain about importing data.
you can 'import' your data into excel if the data is in csv format. that is that the data is seperated by a coma. excel sees each coma as a signal to add the data to the next field.
for example:
name, address, postcode,telephone no
excel would import this and create the fields with the above data and add the data to each field.
each record needs to be on a new line.
For access, you can import an excel file into access in the same manner and it will create the tables for you.
to help you further, please explain how you are gathering your ebay data, and how is the data stored in your web site. the website should explain about importing data.
GrievousAngel
Posts
5
Registration date
Friday October 23, 2009
Status
Member
Last seen
May 7, 2010
Oct 24, 2009 at 07:03 PM
Oct 24, 2009 at 07:03 PM
Right, I understand that. What i am asking is what else do i need to do to map a different db into theoriginal db field/cell nlayout since teh field arrangements are not in the same o5de.
this would appear to be common task but the mechanics of how to cut and paste the fields is not clear to me yet.
thanks,
billy
this would appear to be common task but the mechanics of how to cut and paste the fields is not clear to me yet.
thanks,
billy
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Nov 4, 2009 at 03:51 PM
Nov 4, 2009 at 03:51 PM
Have a read of the following, it may help you.
http://www.exceldigest.com/
http://www.exceldigest.com/
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Nov 11, 2009 at 06:34 PM
Nov 11, 2009 at 06:34 PM
you can have more than one workbook open at one time.
open the workbooks that you require, then select view/arrange all from the ribbon.
you can have each workbook displayed side by side or one above the other.
it's handy if you have 2 monitors as you can then display one work book on one screen and the other on the other screen.
hope that helps
open the workbooks that you require, then select view/arrange all from the ribbon.
you can have each workbook displayed side by side or one above the other.
it's handy if you have 2 monitors as you can then display one work book on one screen and the other on the other screen.
hope that helps
