How to make a Database from a spread sheet and Vlookup
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
How to make a Database from a spread sheet and Vlookup
by Clifton Liles
::
Rate this Message:
Hi All
I am trying to create/populate a Base from a spread sheet. I have followed the vague directions in the help file with no luck. 1 I created a new base with no tables defined and copied the material ( with the first row as headers). Then I pasted it into the Tables area, Paste Special spread sheet. I got the message 'No Table format could be found.'. 2 I created the table and put in an ID field as the Key. Did a Paste Special. I got the message 'No Table format could be found.'. 3 I added the element of the spread sheet that I wanted and did a Paste Special. I got the message 'No Table format could be found.'. From reading this list, I think VLOOKUP may help me do what i want? The only information I have found is for EXECL VLOOKUP, is there any for the OO (Basic?) form? Is it just a Calc function or can I use it in Base? For the record I am using XP and office 3.0.0. Thanks for your Help Cliff -- mailto: c.liles@... Clifton R. Liles "Software to the Stars" lilescr@... Pearland, TX 77581 c.r.liles@... c.liles@... - Speaking for myself! Standard disclaimer applies. - This address may *not* be used for unsolicited mailings. Failure is not an option. It comes bundled with your Microsoft products. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: How to make a Database from a spread sheet and Vlookup
by Olivier Hallot
::
Rate this Message:
As far as I remenber, you can drag a sheet from your spreadsheet into
the table view of Base, and the import will run automagically, with a wizzard to assist you in defining the column data type. Clifton Liles escreveu: > Hi All > I am trying to create/populate a Base from a spread sheet. I have > followed the vague directions in the help file with no luck. > 1 I created a new base with no tables defined and copied the material > ( with the first row as headers). Then I pasted it into the Tables > area, Paste Special spread sheet. I got the message 'No Table format > could be found.'. > 2 I created the table and put in an ID field as the Key. Did a Paste > Special. I got the message 'No Table format could be found.'. > 3 I added the element of the spread sheet that I wanted and did a Paste > Special. I got the message 'No Table format could be found.'. > From reading this list, I think VLOOKUP may help me do what i want? The > only information I have found is for EXECL VLOOKUP, is there any for the > OO (Basic?) form? Is it just a Calc function or can I use it in Base? > > For the record I am using XP and office 3.0.0. > Thanks for your Help > Cliff > Olivier Hallot Scinergy Consulting Tel (021) 2224-3224, (021) 8822-8812 Rio de Janeiro, Brasil http://www.scinergy.com.br OpenOffice.org L10N project leader for Brazil --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: How to make a Database from a spread sheet and Vlookup
by Clifton Liles
::
Rate this Message:
Olivier Hallot wrote:
> As far as I remenber, you can drag a sheet from your spreadsheet into > the table view of Base, and the import will run automagically, with a > wizzard to assist you in defining the column data type. > > Clifton Liles escreveu: >> Hi All >> I am trying to create/populate a Base from a spread sheet. I have >> followed the vague directions in the help file with no luck. >> 1 I created a new base with no tables defined and copied the >> material ( with the first row as headers). Then I pasted it into the >> Tables area, Paste Special spread sheet. I got the message 'No >> Table format could be found.'. >> 2 I created the table and put in an ID field as the Key. Did a Paste >> Special. I got the message 'No Table format could be found.'. >> 3 I added the element of the spread sheet that I wanted and did a >> Paste Special. I got the message 'No Table format could be found.'. >> From reading this list, I think VLOOKUP may help me do what i want? >> The only information I have found is for EXECL VLOOKUP, is there any >> for the OO (Basic?) form? Is it just a Calc function or can I use it >> in Base? >> >> For the record I am using XP and office 3.0.0. >> Thanks for your Help >> Cliff >> > > ------------------------------------------------------------------------ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... I got it to work. The data is a comma separated list from another data base and came up as a Excel data sheet. I opened it as a Calc and then things work. Well not quite what I wanted but with a little playing around I think I can get it. Thanks for your help Cliff -- mailto: c.liles@... Clifton R. Liles "Software to the Stars" lilescr@... Pearland, TX 77581 c.r.liles@... c.liles@... - Speaking for myself! Standard disclaimer applies. - This address may *not* be used for unsolicited mailings. Failure is not an option. It comes bundled with your Microsoft products. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: How to make a Database from a spread sheet and Vlookup
by drewjensen
::
Rate this Message:
Clifton Liles wrote:
> Olivier Hallot wrote: >> As far as I remenber, you can drag a sheet from your spreadsheet into >> the table view of Base, and the import will run automagically, with a >> wizzard to assist you in defining the column data type. >> >> Clifton Liles escreveu: >>> Hi All >>> I am trying to create/populate a Base from a spread sheet. I have >>> followed the vague directions in the help file with no luck. >>> 1 I created a new base with no tables defined and copied the >>> material ( with the first row as headers). Then I pasted it into >>> the Tables area, Paste Special spread sheet. I got the message 'No >>> Table format could be found.'. >>> 2 I created the table and put in an ID field as the Key. Did a >>> Paste Special. I got the message 'No Table format could be found.'. >>> 3 I added the element of the spread sheet that I wanted and did a >>> Paste Special. I got the message 'No Table format could be found.'. >>> From reading this list, I think VLOOKUP may help me do what i want? >>> The only information I have found is for EXECL VLOOKUP, is there any >>> for the OO (Basic?) form? Is it just a Calc function or can I use >>> it in Base? >>> >>> For the record I am using XP and office 3.0.0. >>> Thanks for your Help >>> Cliff >>> >> >> ------------------------------------------------------------------------ >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... > Hi All > I got it to work. The data is a comma separated list from another > data base and came up as a Excel data sheet. I opened it as a Calc > and then things work. Well not quite what I wanted but with a little > playing around I think I can get it. Thanks for your help > Cliff > Hi Clifton, OK - well I know this is late. The best way that I've found to move the data from Calc to Base is a 3 file transfer. 1 - I create a base file as 'Connect to eisting' in the wizard and select a type of Spreadsheet. - Select the Calc file with the data you want to move to base 2 - Create your Base file (embedded, MySQL, whatever) 3 -Now drag your data as a 'table' from that first file to the second, launching the table copy wizard. My personal experience has been that this gives the best results for transferring the data. Drew --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
| Free embeddable forum powered by Nabble | Forum Help |
