unknow link specificationsThis is a discussion on unknow link specifications within the ADO DAO RDO RDS forums in Framework and Interface Programming category; Folks, thank you in advance for your help. I have a directory of tab delimited text data files I would like to link to my database (programmiclly) and do some processing(programmiclly). Each text file has a header row of field names and then the data. I have no way of wading thru the hundreds of files and using the link wizard to manually create a link/import specification. I need all the data types to be text. I have used Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md which gives me only 1 unseparted field of data. Same for DoCmd.TransferText acLinkDelim,xxx,xxx,xxx The big problem is creating the ... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
11-06-2008, 01:26 PM
| |||
| |||
 unknow link specifications Folks, thank you in advance for your help. I have a directory of tab delimited text data files I would like to link to my database (programmiclly) and do some processing(programmiclly). Each text file has a header row of field names and then the data. I have no way of wading thru the hundreds of files and using the link wizard to manually create a link/import specification. I need all the data types to be text. I have used Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md which gives me only 1 unseparted field of data. Same for DoCmd.TransferText acLinkDelim,xxx,xxx,xxx The big problem is creating the link specification on the fly. Thanks for any help.  |
|
#2
11-06-2008, 01:33 PM
| |||
| |||
| Re: unknow link specifications Do you need all of the files linked at once? If not, why not create a single link specification. You could then rename each file to the appropriate name, link it, process it, unlink it, then rename the file back. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... > Folks, thank you in advance for your help. > I have a directory of tab delimited text data files I would like to link > to > my database (programmiclly) and do some processing(programmiclly). Each > text > file has a header row of field names and then the data. I have no way of > wading thru the hundreds of files and using the link wizard to manually > create a link/import specification. I need all the data types to be text. > I > have used > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > which gives me only 1 unseparted field of data. Same for > DoCmd.TransferText > acLinkDelim,xxx,xxx,xxx > The big problem is creating the link specification on the fly. Thanks for > any help. |
|
#3
11-06-2008, 01:59 PM
| |||
| |||
| Re: unknow link specifications Doug, Thanks for replying. I do not need them all at one but the problem is the single link specification. Each file has a unique set of data fields that I exam and process individually. I do not know the number of fields nor the names until I do the processing but I can not process until I create the linked/imported table. i.e table1---- fldAN, KUP, SAP, JJJ table2 --- xxx, yyy, sup, sap etc. "Douglas J. Steele" wrote: > Do you need all of the files linked at once? > > If not, why not create a single link specification. You could then rename > each file to the appropriate name, link it, process it, unlink it, then > rename the file back. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... > > Folks, thank you in advance for your help. > > I have a directory of tab delimited text data files I would like to link > > to > > my database (programmiclly) and do some processing(programmiclly). Each > > text > > file has a header row of field names and then the data. I have no way of > > wading thru the hundreds of files and using the link wizard to manually > > create a link/import specification. I need all the data types to be text. > > I > > have used > > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > > which gives me only 1 unseparted field of data. Same for > > DoCmd.TransferText > > acLinkDelim,xxx,xxx,xxx > > The big problem is creating the link specification on the fly. Thanks for > > any help. > > > |
|
#4
11-06-2008, 03:04 PM
| |||
| |||
| Re: unknow link specifications You may have to read the files in using the Line Input # statement and parse them yourself in VBA. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message news:8F0C6306-C95C-442E-A473-5568D7074F5E@microsoft.com... > > Doug, Thanks for replying. > I do not need them all at one but the problem is the single link > specification. Each file has a unique set of data fields that I exam and > process individually. I do not know the number of fields nor the names > until > I do the processing but I can not process until I create the > linked/imported > table. > i.e table1---- fldAN, KUP, SAP, JJJ > table2 --- xxx, yyy, sup, sap > etc. > > "Douglas J. Steele" wrote: > >> Do you need all of the files linked at once? >> >> If not, why not create a single link specification. You could then rename >> each file to the appropriate name, link it, process it, unlink it, then >> rename the file back. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message >> news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... >> > Folks, thank you in advance for your help. >> > I have a directory of tab delimited text data files I would like to >> > link >> > to >> > my database (programmiclly) and do some processing(programmiclly). Each >> > text >> > file has a header row of field names and then the data. I have no way >> > of >> > wading thru the hundreds of files and using the link wizard to manually >> > create a link/import specification. I need all the data types to be >> > text. >> > I >> > have used >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md >> > which gives me only 1 unseparted field of data. Same for >> > DoCmd.TransferText >> > acLinkDelim,xxx,xxx,xxx >> > The big problem is creating the link specification on the fly. Thanks >> > for >> > any help. >> >> >> |
|
#5
11-06-2008, 03:29 PM
| |||
| |||
| Re: unknow link specifications Doug, the files are all tab separated TSV. I changed one file to CSV and the statement: Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md works. Do you know of a way to have the format FMT=TabDelimited? I tried that FMT=TabDelimited ; FMT=Delimited(" & vbTab & ") and FMT=Delimited("<delimiter>") as suggestion from a web search but they had no effect unlike the CSV which works completely. I could write a parser but it seems like there should be an easy way to create a link/import specification on the fly. Any thoughts are appreciated. "Douglas J. Steele" wrote: > You may have to read the files in using the Line Input # statement and parse > them yourself in VBA. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > news:8F0C6306-C95C-442E-A473-5568D7074F5E@microsoft.com... > > > > Doug, Thanks for replying. > > I do not need them all at one but the problem is the single link > > specification. Each file has a unique set of data fields that I exam and > > process individually. I do not know the number of fields nor the names > > until > > I do the processing but I can not process until I create the > > linked/imported > > table. > > i.e table1---- fldAN, KUP, SAP, JJJ > > table2 --- xxx, yyy, sup, sap > > etc. > > > > "Douglas J. Steele" wrote: > > > >> Do you need all of the files linked at once? > >> > >> If not, why not create a single link specification. You could then rename > >> each file to the appropriate name, link it, process it, unlink it, then > >> rename the file back. > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://I.Am/DougSteele > >> (no e-mails, please!) > >> > >> > >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > >> news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... > >> > Folks, thank you in advance for your help. > >> > I have a directory of tab delimited text data files I would like to > >> > link > >> > to > >> > my database (programmiclly) and do some processing(programmiclly). Each > >> > text > >> > file has a header row of field names and then the data. I have no way > >> > of > >> > wading thru the hundreds of files and using the link wizard to manually > >> > create a link/import specification. I need all the data types to be > >> > text. > >> > I > >> > have used > >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > >> > which gives me only 1 unseparted field of data. Same for > >> > DoCmd.TransferText > >> > acLinkDelim,xxx,xxx,xxx > >> > The big problem is creating the link specification on the fly. Thanks > >> > for > >> > any help. > >> > >> > >> > > > |
|
#6
11-06-2008, 07:17 PM
| |||
| |||
| Re: unknow link specifications See whether Format=TabDelimited works You might also check http://msdn2.microsoft.com/library/ms709353.aspx -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message news:435C896C-30C8-41E1-AEE4-2649138BA709@microsoft.com... > Doug, the files are all tab separated TSV. I changed one file to CSV and > the > statement: > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > works. Do you know of a way to have the format FMT=TabDelimited? I tried > that FMT=TabDelimited ; FMT=Delimited(" & vbTab & ") and > FMT=Delimited("<delimiter>") as suggestion from a web search but they had > no > effect unlike the CSV which works completely. I could write a parser but > it > seems like there should be an easy way to create a link/import > specification > on the fly. > Any thoughts are appreciated. > > "Douglas J. Steele" wrote: > >> You may have to read the files in using the Line Input # statement and >> parse >> them yourself in VBA. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message >> news:8F0C6306-C95C-442E-A473-5568D7074F5E@microsoft.com... >> > >> > Doug, Thanks for replying. >> > I do not need them all at one but the problem is the single link >> > specification. Each file has a unique set of data fields that I exam >> > and >> > process individually. I do not know the number of fields nor the names >> > until >> > I do the processing but I can not process until I create the >> > linked/imported >> > table. >> > i.e table1---- fldAN, KUP, SAP, JJJ >> > table2 --- xxx, yyy, sup, sap >> > etc. >> > >> > "Douglas J. Steele" wrote: >> > >> >> Do you need all of the files linked at once? >> >> >> >> If not, why not create a single link specification. You could then >> >> rename >> >> each file to the appropriate name, link it, process it, unlink it, >> >> then >> >> rename the file back. >> >> >> >> -- >> >> Doug Steele, Microsoft Access MVP >> >> http://I.Am/DougSteele >> >> (no e-mails, please!) >> >> >> >> >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message >> >> news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... >> >> > Folks, thank you in advance for your help. >> >> > I have a directory of tab delimited text data files I would like to >> >> > link >> >> > to >> >> > my database (programmiclly) and do some processing(programmiclly). >> >> > Each >> >> > text >> >> > file has a header row of field names and then the data. I have no >> >> > way >> >> > of >> >> > wading thru the hundreds of files and using the link wizard to >> >> > manually >> >> > create a link/import specification. I need all the data types to be >> >> > text. >> >> > I >> >> > have used >> >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md >> >> > which gives me only 1 unseparted field of data. Same for >> >> > DoCmd.TransferText >> >> > acLinkDelim,xxx,xxx,xxx >> >> > The big problem is creating the link specification on the fly. >> >> > Thanks >> >> > for >> >> > any help. >> >> >> >> >> >> >> >> >> |
|
#7
11-06-2008, 09:33 PM
| |||
| |||
| Re: unknow link specifications The article and others say that Format=TabDelimited should work but the link still comes back to only 1 field. I have also used the Format=Delimited(vbTab) and chr(9). These do not work thus far. Any other suggestions. "Douglas J. Steele" wrote: > See whether Format=TabDelimited works > > You might also check http://msdn2.microsoft.com/library/ms709353.aspx > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > news:435C896C-30C8-41E1-AEE4-2649138BA709@microsoft.com... > > Doug, the files are all tab separated TSV. I changed one file to CSV and > > the > > statement: > > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > > works. Do you know of a way to have the format FMT=TabDelimited? I tried > > that FMT=TabDelimited ; FMT=Delimited(" & vbTab & ") and > > FMT=Delimited("<delimiter>") as suggestion from a web search but they had > > no > > effect unlike the CSV which works completely. I could write a parser but > > it > > seems like there should be an easy way to create a link/import > > specification > > on the fly. > > Any thoughts are appreciated. > > > > "Douglas J. Steele" wrote: > > > >> You may have to read the files in using the Line Input # statement and > >> parse > >> them yourself in VBA. > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://I.Am/DougSteele > >> (no e-mails, please!) > >> > >> > >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > >> news:8F0C6306-C95C-442E-A473-5568D7074F5E@microsoft.com... > >> > > >> > Doug, Thanks for replying. > >> > I do not need them all at one but the problem is the single link > >> > specification. Each file has a unique set of data fields that I exam > >> > and > >> > process individually. I do not know the number of fields nor the names > >> > until > >> > I do the processing but I can not process until I create the > >> > linked/imported > >> > table. > >> > i.e table1---- fldAN, KUP, SAP, JJJ > >> > table2 --- xxx, yyy, sup, sap > >> > etc. > >> > > >> > "Douglas J. Steele" wrote: > >> > > >> >> Do you need all of the files linked at once? > >> >> > >> >> If not, why not create a single link specification. You could then > >> >> rename > >> >> each file to the appropriate name, link it, process it, unlink it, > >> >> then > >> >> rename the file back. > >> >> > >> >> -- > >> >> Doug Steele, Microsoft Access MVP > >> >> http://I.Am/DougSteele > >> >> (no e-mails, please!) > >> >> > >> >> > >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > >> >> news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... > >> >> > Folks, thank you in advance for your help. > >> >> > I have a directory of tab delimited text data files I would like to > >> >> > link > >> >> > to > >> >> > my database (programmiclly) and do some processing(programmiclly). > >> >> > Each > >> >> > text > >> >> > file has a header row of field names and then the data. I have no > >> >> > way > >> >> > of > >> >> > wading thru the hundreds of files and using the link wizard to > >> >> > manually > >> >> > create a link/import specification. I need all the data types to be > >> >> > text. > >> >> > I > >> >> > have used > >> >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > >> >> > which gives me only 1 unseparted field of data. Same for > >> >> > DoCmd.TransferText > >> >> > acLinkDelim,xxx,xxx,xxx > >> >> > The big problem is creating the link specification on the fly. > >> >> > Thanks > >> >> > for > >> >> > any help. > >> >> > >> >> > >> >> > >> > >> > >> > > > |
|
#8
11-07-2008, 09:51 AM
| |||
| |||
| Re: unknow link specifications You seem to have already rejected my other suggestion, which was to use VBA to import the data. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message news:99EB8BC4-9C19-42EF-A1C1-A88ACBEBCDA8@microsoft.com... > > The article and others say that Format=TabDelimited should work but the > link still comes back to only 1 field. I have also used the > Format=Delimited(vbTab) and chr(9). These do not work thus far. Any other > suggestions. > > "Douglas J. Steele" wrote: > >> See whether Format=TabDelimited works >> >> You might also check http://msdn2.microsoft.com/library/ms709353.aspx >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message >> news:435C896C-30C8-41E1-AEE4-2649138BA709@microsoft.com... >> > Doug, the files are all tab separated TSV. I changed one file to CSV >> > and >> > the >> > statement: >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md >> > works. Do you know of a way to have the format FMT=TabDelimited? I >> > tried >> > that FMT=TabDelimited ; FMT=Delimited(" & vbTab & ") and >> > FMT=Delimited("<delimiter>") as suggestion from a web search but they >> > had >> > no >> > effect unlike the CSV which works completely. I could write a parser >> > but >> > it >> > seems like there should be an easy way to create a link/import >> > specification >> > on the fly. >> > Any thoughts are appreciated. >> > >> > "Douglas J. Steele" wrote: >> > >> >> You may have to read the files in using the Line Input # statement and >> >> parse >> >> them yourself in VBA. >> >> >> >> -- >> >> Doug Steele, Microsoft Access MVP >> >> http://I.Am/DougSteele >> >> (no e-mails, please!) >> >> >> >> >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message >> >> news:8F0C6306-C95C-442E-A473-5568D7074F5E@microsoft.com... >> >> > >> >> > Doug, Thanks for replying. >> >> > I do not need them all at one but the problem is the single link >> >> > specification. Each file has a unique set of data fields that I exam >> >> > and >> >> > process individually. I do not know the number of fields nor the >> >> > names >> >> > until >> >> > I do the processing but I can not process until I create the >> >> > linked/imported >> >> > table. >> >> > i.e table1---- fldAN, KUP, SAP, JJJ >> >> > table2 --- xxx, yyy, sup, sap >> >> > etc. >> >> > >> >> > "Douglas J. Steele" wrote: >> >> > >> >> >> Do you need all of the files linked at once? >> >> >> >> >> >> If not, why not create a single link specification. You could then >> >> >> rename >> >> >> each file to the appropriate name, link it, process it, unlink it, >> >> >> then >> >> >> rename the file back. >> >> >> >> >> >> -- >> >> >> Doug Steele, Microsoft Access MVP >> >> >> http://I.Am/DougSteele >> >> >> (no e-mails, please!) >> >> >> >> >> >> >> >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message >> >> >> news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... >> >> >> > Folks, thank you in advance for your help. >> >> >> > I have a directory of tab delimited text data files I would like >> >> >> > to >> >> >> > link >> >> >> > to >> >> >> > my database (programmiclly) and do some >> >> >> > processing(programmiclly). >> >> >> > Each >> >> >> > text >> >> >> > file has a header row of field names and then the data. I have no >> >> >> > way >> >> >> > of >> >> >> > wading thru the hundreds of files and using the link wizard to >> >> >> > manually >> >> >> > create a link/import specification. I need all the data types to >> >> >> > be >> >> >> > text. >> >> >> > I >> >> >> > have used >> >> >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md >> >> >> > which gives me only 1 unseparted field of data. Same for >> >> >> > DoCmd.TransferText >> >> >> > acLinkDelim,xxx,xxx,xxx >> >> >> > The big problem is creating the link specification on the fly. >> >> >> > Thanks >> >> >> > for >> >> >> > any help. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> |
|
#9
11-10-2008, 11:06 AM
| |||
| |||
| Re: unknow link specifications Doug, Thanks for your help. I created a parser for the 1 field import. I still wonder why the Format=TabDelimited does not work in a connect string as does the default Format=Delimited(which assumes comma). Even the article you suggested say that it should work but alas no go. Thanks again. "Douglas J. Steele" wrote: > You seem to have already rejected my other suggestion, which was to use VBA > to import the data. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > news:99EB8BC4-9C19-42EF-A1C1-A88ACBEBCDA8@microsoft.com... > > > > The article and others say that Format=TabDelimited should work but the > > link still comes back to only 1 field. I have also used the > > Format=Delimited(vbTab) and chr(9). These do not work thus far. Any other > > suggestions. > > > > "Douglas J. Steele" wrote: > > > >> See whether Format=TabDelimited works > >> > >> You might also check http://msdn2.microsoft.com/library/ms709353.aspx > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://I.Am/DougSteele > >> (no private e-mails, please) > >> > >> > >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > >> news:435C896C-30C8-41E1-AEE4-2649138BA709@microsoft.com... > >> > Doug, the files are all tab separated TSV. I changed one file to CSV > >> > and > >> > the > >> > statement: > >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > >> > works. Do you know of a way to have the format FMT=TabDelimited? I > >> > tried > >> > that FMT=TabDelimited ; FMT=Delimited(" & vbTab & ") and > >> > FMT=Delimited("<delimiter>") as suggestion from a web search but they > >> > had > >> > no > >> > effect unlike the CSV which works completely. I could write a parser > >> > but > >> > it > >> > seems like there should be an easy way to create a link/import > >> > specification > >> > on the fly. > >> > Any thoughts are appreciated. > >> > > >> > "Douglas J. Steele" wrote: > >> > > >> >> You may have to read the files in using the Line Input # statement and > >> >> parse > >> >> them yourself in VBA. > >> >> > >> >> -- > >> >> Doug Steele, Microsoft Access MVP > >> >> http://I.Am/DougSteele > >> >> (no e-mails, please!) > >> >> > >> >> > >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > >> >> news:8F0C6306-C95C-442E-A473-5568D7074F5E@microsoft.com... > >> >> > > >> >> > Doug, Thanks for replying. > >> >> > I do not need them all at one but the problem is the single link > >> >> > specification. Each file has a unique set of data fields that I exam > >> >> > and > >> >> > process individually. I do not know the number of fields nor the > >> >> > names > >> >> > until > >> >> > I do the processing but I can not process until I create the > >> >> > linked/imported > >> >> > table. > >> >> > i.e table1---- fldAN, KUP, SAP, JJJ > >> >> > table2 --- xxx, yyy, sup, sap > >> >> > etc. > >> >> > > >> >> > "Douglas J. Steele" wrote: > >> >> > > >> >> >> Do you need all of the files linked at once? > >> >> >> > >> >> >> If not, why not create a single link specification. You could then > >> >> >> rename > >> >> >> each file to the appropriate name, link it, process it, unlink it, > >> >> >> then > >> >> >> rename the file back. > >> >> >> > >> >> >> -- > >> >> >> Doug Steele, Microsoft Access MVP > >> >> >> http://I.Am/DougSteele > >> >> >> (no e-mails, please!) > >> >> >> > >> >> >> > >> >> >> "CJ_DB" <CJDB@discussions.microsoft.com> wrote in message > >> >> >> news:1337E9D9-1DFB-4372-A7B2-5B1E82D1B6EE@microsoft.com... > >> >> >> > Folks, thank you in advance for your help. > >> >> >> > I have a directory of tab delimited text data files I would like > >> >> >> > to > >> >> >> > link > >> >> >> > to > >> >> >> > my database (programmiclly) and do some > >> >> >> > processing(programmiclly). > >> >> >> > Each > >> >> >> > text > >> >> >> > file has a header row of field names and then the data. I have no > >> >> >> > way > >> >> >> > of > >> >> >> > wading thru the hundreds of files and using the link wizard to > >> >> >> > manually > >> >> >> > create a link/import specification. I need all the data types to > >> >> >> > be > >> >> >> > text. > >> >> >> > I > >> >> >> > have used > >> >> >> > Text;;FMT=Delimited;HDR=Yes;IMEX=1;CharacterSet=43 7;DATABASE=xxx.md > >> >> >> > which gives me only 1 unseparted field of data. Same for > >> >> >> > DoCmd.TransferText > >> >> >> > acLinkDelim,xxx,xxx,xxx > >> >> >> > The big problem is creating the link specification on the fly. > >> >> >> > Thanks > >> >> >> > for > >> >> >> > any help. > >> >> >> > >> >> >> > >> >> >> > >> >> > >> >> > >> >> > >> > >> > >> > > > |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 10:23 AM.
