By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

text file as data source for query

P: n/a
hello,
in query my data source is text file.
i execute this in this way:

SELECT * FROM [Text;Database=C:\?cie?ka;HDR=Yes;FMT=Delimited].[plik.txt];

question:
how to in this select i may write, that column separator is tab and how to
write, which row is first in my source?

sorry, but my english is on begginer level :-|
/best regards
--
~> Code_rEd
~> gg#3006187
~> uin#246128260
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You are probably better off linking your text file as a table. Go to
the Tables tab and click the New button to add a new table. In the New
Table dialog box select 'Link Table'. In the Link dialog box, specify
'Text Files' as the 'Files of type:' to be linked. Then specify which
text file you want to link and click the Link button. From there the
Link Text Wizard will let you specify that you want to use the Tab
character as a delimiter and whether or not the first line of your text
file specifies the column names. Once you have done this you can use
your text file as the source of a query.

Bruce

Nov 13 '05 #2

P: n/a
Osoba podpisujaca sie jako br***@aristotle.net popelnila na
comp.databases.ms-access co nastepuje:
You are probably better off linking your text file as a table.

<cut>

hello Bruce,
thank you for your answer... but i don't want linking this file.
I must have it as source in query, so i choose this way to querying this
data.
that is still trouble for me :-|
--
~> best regards,
~> Code_rEd
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.