Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Excel to a text file database
I use vlookup to access data from within my spreadsheet. The extensive
dataset I have is on one of the sheets and is large and cumbersome. I understand that it is possible to link my sheet to an ancillary text file within which i can store my database. How does one go about doing this and will vlookup work? Can anyone help or redirect me? Thanks, Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Excel to a text file database
You m,ay be able to save the one worksheet in CSV format. Then link to the
CSV file. You can create the CSV file by just performing a SAVEAS selecting CSV as the file type. A warning will come up saying that you will loose the format and that only one sheet at a time can be saved in this format. A CSV file is both a text and a Excel file as the same time. The CSV is COMMA SEPERATED VALUES which uses commas to sperate data from one column to the next like abc, def, ghi next row data, jkl,mno,pqr abc will go into column A. def will go into column B. ghi will go into column C. next row data will go into row 2 Column A. jkl will go into row 2 Column B. mno will go into Row 2 Column C pqr will go into row 2 column D. "Roger on Excel" wrote: I use vlookup to access data from within my spreadsheet. The extensive dataset I have is on one of the sheets and is large and cumbersome. I understand that it is possible to link my sheet to an ancillary text file within which i can store my database. How does one go about doing this and will vlookup work? Can anyone help or redirect me? Thanks, Roger |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Excel to a text file database
Thanks Joel,
I will give it a try Roger "Joel" wrote: You m,ay be able to save the one worksheet in CSV format. Then link to the CSV file. You can create the CSV file by just performing a SAVEAS selecting CSV as the file type. A warning will come up saying that you will loose the format and that only one sheet at a time can be saved in this format. A CSV file is both a text and a Excel file as the same time. The CSV is COMMA SEPERATED VALUES which uses commas to sperate data from one column to the next like abc, def, ghi next row data, jkl,mno,pqr abc will go into column A. def will go into column B. ghi will go into column C. next row data will go into row 2 Column A. jkl will go into row 2 Column B. mno will go into Row 2 Column C pqr will go into row 2 column D. "Roger on Excel" wrote: I use vlookup to access data from within my spreadsheet. The extensive dataset I have is on one of the sheets and is large and cumbersome. I understand that it is possible to link my sheet to an ancillary text file within which i can store my database. How does one go about doing this and will vlookup work? Can anyone help or redirect me? Thanks, Roger |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Excel to a text file database
Although running SQL on text files is amazingly fast (considering there are
no indexes) there might be an advantage to move to a real database like SQLite. Very simple, very fast and very good free VB(A) wrapper available. Not sure you were thinking of using SQL, but I think when your lookups are getting complex using SQL will make it a lot simpler. RBS "Roger on Excel" wrote in message ... I use vlookup to access data from within my spreadsheet. The extensive dataset I have is on one of the sheets and is large and cumbersome. I understand that it is possible to link my sheet to an ancillary text file within which i can store my database. How does one go about doing this and will vlookup work? Can anyone help or redirect me? Thanks, Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Access Database to Excel | Excel Discussion (Misc queries) | |||
linking data from text file on ftp server to excel file | Excel Programming | |||
Linking access database to an excel file | Excel Discussion (Misc queries) | |||
Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
Linking sumif from external database file | Setting up and Configuration of Excel |