DataBase - ACCESS Combining fields
Asked By MJR
12-Nov-09 01:34 PM
I have exported data to a Excel XLS file then I import it into access. The
fields look like this:
Host_N IP Address Interface - Name
OS Name
Server_03 192.168.1.110 Server_03.sx.company.com
MS W2K3 R2
Server_03 192.168.1.123 Server_03-rib.sx.company.com
MS W2K3 R2
Server_04 192.168.1.103 Server_04.sx.company.com
MS W2K3 R2
Server_04 192.168.1.126 Server_04-rib.sx.company.com
MS W2K3 R2
Server_04 192.168.1.105 portal.web.company.com
MS W2K3 R2
Server_04 192.168.1.64 mysites.web.company.com
MS W2K3 R2
I.E. Server_04 lists 4 ip addresses, 4 Interface names
Is there a way to create 1 record for server_04 and combine the 4 ip
addresses into 1 field (or combo box or other) and the multiple interface
names?
I am lost.
Excel
(1)
Database
(1)
DougSteele
(1)
Douglas J. Steele replied to MJR
it is possible, but most people would consider it a bad idea.
You're using a relational database. Use it relationally! Each field should
contain one, and only one, piece of information.
Perhaps if you can explain what you are trying to do, someone can offer a
solution.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
Link with Excel DataBase Hi I know how to link Excel files with Access database, but I am wondering if 1) we can link Excel file starting row 6 (row 6 bacame heading) 2) I have the file called "AAA previous fale and is called "AAA-Fab-09". I would like to link Access with Excel for files called "AAA*". I do not know if it is possible - - Greatly appreciated Eva Access Discussions Excel (1) VBA (1) Database (1) DougSteele (1) AppreciatedEva (1) Bacame (1) Month (1) Fale (1) Unfortunately, you can only
Query in excel DataBase Hi, I have list of list of around 5000 companies, but in that, companies are the repeated companies? Sorting will not work in this. Regards, Ashwini Access Discussions Office (1) Excel (1) Database (1) DougSteele (1) Bontrager (1) Ispart (1) This newsgroup is for questions about Access, the database product that is part of Office Professional. If you are trying to do this in Excel, you would be best off reposting to a newsgroup related to Excel. If, on the other hand, you are working in Access, linked to an Excel spreadsheet
close excel DataBase hi, i have a module in access which opens an excel file and runs a module within the excel file. What is the best way to add code to the access module to completely close excel and then close access. Because I noticed in the task manager that excel is still running afterwards. thanks i advance, geebee Access Modules Coding Discussions Excel (1) CreateObject (1) DougSteele (1) ObjXL (1) ObjExcel (1) Failedto (1) Presumably you have instantiated some variable as an
EXCEL 09 file containing macros is not opening DataBase Excel 2009 on Windows XP. I have trouble opening an xls file. When I try to open the file eihter from folder or from FILE menu of MS Excel, I get Microsoft Security Alert message box which prompts me to Enable or Disable Macros help if anybody encountered a similar situation. - - Atif Access Macros Discussions Windows XP (1) Microsoft Excel (1) Office (1) Excel (1) Database (1) DougSteele (1) MAtif (1) Atif (1) Sorry, but this newsgroup is for questions about macros in
Paste Access into Excel DataBase Excel and Access 2002 SP3 I asked this several days ago in the Excel forum but so far no response. User copies a street address from Access; she wants to paste it into an Excel document. Previously created documents paste the entire street address into a single cell. Now the each word in a separate cell. We copied her document to a new spreadsheet (corrupt Excel document?) and got the same results. We created a new, blank Excel document and pasted into it with the same results. The user opens an existing document only workaround so far is to paste into Word, then copy / paste from Word to Excel and it works. Can anyone offer any insight into what has changed here because we