I need to import multiple tab delimited files for which I do not have
the formats. All files have column headers in the the line. The
files must be dynamic. The only common value is that the files are
text and use tabs to delimit the column data.
I can not use the File/Import as people using the program do not have
the necessary experience to perform this function. Therefore, I need
to programtically create unique tables for each text file. 7 12169
On 17 Feb 2007 14:32:21 -0800, "Pete" <pe********@comcast.netwrote:
Don't import them; just attach to them, which automatically creates
the correct columns.
-Tom.
>I need to import multiple tab delimited files for which I do not have the formats. All files have column headers in the the line. The files must be dynamic. The only common value is that the files are text and use tabs to delimit the column data.
I can not use the File/Import as people using the program do not have the necessary experience to perform this function. Therefore, I need to programtically create unique tables for each text file.
On Feb 17, 6:24 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On 17 Feb 2007 14:32:21 -0800, "Pete" <petebea...@comcast.netwrote:
Don't import them; just attach to them, which automatically creates
the correct columns.
-Tom.
I need to import multiple tab delimited files for which I do not have
the formats. All files have column headers in the the line. The
files must be dynamic. The only common value is that the files are
text and use tabs to delimit the column data.
I can not use the File/Import as people using the program do not have
the necessary experience to perform this function. Therefore, I need
to programtically create unique tables for each text file.- Hide quoted text -
- Show quoted text -
I can not append the files. There is no existing table. I need to
create tables from each new file without knowing the column names or
content.
"Pete" <pe********@comcast.netwrote in
news:11*********************@m58g2000cwm.googlegro ups.com:
I need to import multiple tab delimited files for which I do
not have the formats. All files have column headers in the
the line. The files must be dynamic. The only common value
is that the files are text and use tabs to delimit the column
data.
I can not use the File/Import as people using the program do
not have the necessary experience to perform this function.
Therefore, I need to programtically create unique tables for
each text file.
I'd attack this by using the low-level file manipulation
functions in VBA (open #1, get #1) to read each line of the file
into a string variable or one column table, then use a loop to
read the column names, create the table from that (but here
you'll have to guess at the column type), then loop through each
row to find the tabs, writing out the values to the appropriate
column.
It is much too much code to post on a newsgroup.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
Hi, Pete.
I need to import multiple tab delimited files for which I do not have
the formats.
.. . .
I can not use the File/Import as people using the program do not have
the necessary experience to perform this function.
What sort of magic do you intend to use to read the data type specifications
from the file and create the "dynamic" tables with them?
Therefore, I need
to programtically create unique tables for each text file.
You could link to these text files as tables, but database applications rely
on stable database structures. Otherwise, those database applications
aren't going to be stable -- or very practical.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Pete" <pe********@comcast.netwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...
>I need to import multiple tab delimited files for which I do not have
the formats. All files have column headers in the the line. The
files must be dynamic. The only common value is that the files are
text and use tabs to delimit the column data.
I can not use the File/Import as people using the program do not have
the necessary experience to perform this function. Therefore, I need
to programtically create unique tables for each text file.
On Feb 17, 6:38 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:
Hi, Pete.
I need to import multiple tab delimited files for which I do not have
the formats.
. . .
I can not use the File/Import as people using the program do not have
the necessary experience to perform this function.
What sort of magic do you intend to use to read the data type specifications
from the file and create the "dynamic" tables with them?
Therefore, I need
to programtically create unique tables for each text file.
You could link to these text files as tables, but database applications rely
on stable database structures. Otherwise, those database applications
aren't going to be stable -- or very practical.
HTH.
Gunny
Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.comhttp...utors2.htmlfor contact
info.
"Pete" <petebea...@comcast.netwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...
I need to import multiple tab delimited files for which I do not have
the formats. All files have column headers in the the line. The
files must be dynamic. The only common value is that the files are
text and use tabs to delimit the column data.
I can not use the File/Import as people using the program do not have
the necessary experience to perform this function. Therefore, I need
to programtically create unique tables for each text file.- Hide quoted text -
- Show quoted text -
If I open a sample txt file using the file/import, the wizard
automatically find the correct structure. The only thing that I need
to set is the Tab and the header indicators.
I need a way to duplicate this function in the code and set the taba
and header indicators. I know I can tell the TransferText to use the
first line as the column headers. However, I can not set the tab
indicator.
"Pete" <pe********@comcast.netwrote in message
news:11*********************@l53g2000cwa.googlegro ups.com...
On Feb 17, 6:24 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On 17 Feb 2007 14:32:21 -0800, "Pete" <petebea...@comcast.netwrote:
Don't import them; just attach to them, which automatically creates the correct columns.
-Tom.
>I need to import multiple tab delimited files for which I do not have the formats. All files have column headers in the the line. The files must be dynamic. The only common value is that the files are text and use tabs to delimit the column data.
>I can not use the File/Import as people using the program do not have the necessary experience to perform this function. Therefore, I need to programtically create unique tables for each text file.- Hide quoted text -
- Show quoted text -
I can not append the files. There is no existing table. I need to
create tables from each new file without knowing the column names or
content.
I don't see where Tom suggested anything about "appending" to an existing
table.
What he was talking about was, on the menu "File" then "Get External Data"
then "Link Table" then browse for the table, then follow the prompts. I just
created a tab-delimited text file, and stepped through the process -- if
that's too complicated for you to teach your users, I'll have to say I've
never, in nearly 50 years in the computer business, worked with users so
"learning disadvantaged".
Larry Linson
Microsoft Access MVP
On Mon, 19 Feb 2007 02:14:31 GMT, "Larry Linson"
<bo*****@localhost.notwrote:
Plus you can do this programmatically.
-Tom.
> "Pete" <pe********@comcast.netwrote in message news:11*********************@l53g2000cwa.googlegr oups.com...
>On Feb 17, 6:24 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>>On 17 Feb 2007 14:32:21 -0800, "Pete" <petebea...@comcast.netwrote:
Don't import them; just attach to them, which automatically creates the correct columns.
-Tom. I need to import multiple tab delimited files for which I do not have the formats. All files have column headers in the the line. The files must be dynamic. The only common value is that the files are text and use tabs to delimit the column data.
I can not use the File/Import as people using the program do not have the necessary experience to perform this function. Therefore, I need to programtically create unique tables for each text file.- Hide quoted text -
- Show quoted text -
I can not append the files. There is no existing table. I need to create tables from each new file without knowing the column names or content.
I don't see where Tom suggested anything about "appending" to an existing table.
What he was talking about was, on the menu "File" then "Get External Data" then "Link Table" then browse for the table, then follow the prompts. I just created a tab-delimited text file, and stepped through the process -- if that's too complicated for you to teach your users, I'll have to say I've never, in nearly 50 years in the computer business, worked with users so "learning disadvantaged".
Larry Linson
Microsoft Access MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: atse |
last post by:
Hi,
I still have problem to import the text file delimited by tabs or commas
into the database.
I refer to http://www.connectionstrings.com/ for the connection, ODBC
doesn't work and OLD DB...
|
by: Ashish Kanoongo |
last post by:
I am using following connectstring and it works with CSV delimmited file
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & ";" & _
"Extended...
|
by: Paulo Jan |
last post by:
Hi all:
Let's say I'm designing a database (Postgres 7.3) with a list of all
email accounts in a certain server:
CREATE TABLE emails (
clienteid INT4,
direccion VARCHAR(512) PRIMARY KEY,...
|
by: DCM Fan |
last post by:
Access 2K, SP3 on Windows 2K, SP4
All,
I have an import spec set up with quoted Identifiers and comma-separated
values. The text file is produced by a 3rd-party program of which I have no...
|
by: mark |
last post by:
In Access 2000 and 2002, I have created an import specification to import the
fixed-width recordset below into an existing table. I am having strange
problems with the import of the date and time...
|
by: Masa Ito |
last post by:
I have pipe delimited (and comma/tab) files that I read with JET using a
schema file. Occasionally a field has multiple quotes (") inside a single
field - which chokes the line (the rest of the...
|
by: Shawn Ferguson |
last post by:
With the help of you, I've been able to successfully load my database with the contents of a "comma" delimited file. It loads about 5000 records in about 3 seconds:) Now I have another problem. ...
|
by: Alvin SIU |
last post by:
Hi all,
I have 6 tables inside a MS Access 2003 mdb file.
I want to convert them as DB2 version -8 tables in AIX 5.2.
I have exported them as 6 XML files.
The XML files look fine.
Each...
|
by: geolemon |
last post by:
Import text wizard says:
I'm banging my head on this one, here's why:
I've been importing files using this process and data format, with success!
I created a temporary table in Access to...
|
by: Rina0 |
last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: linyimin |
last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
|
by: kcodez |
last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
|
by: DJRhino1175 |
last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this -
If...
|
by: Rina0 |
last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
|
by: DJRhino |
last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer)
If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _
310030356 Or 310030359 Or 310030362 Or...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: Mushico |
last post by:
How to calculate date of retirement from date of birth
| |