473,322 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Need to link a text file.

Hi All,
This is my first time - I just would like to get some help in linking a txt file in MS access the file looks like this :-

XX061020082120
XX061020083140

And so on
What i need is to import them in a different 3 different fields,
XX first field Text format
061020 second field date format in (D/M/Y) currently its in (Y/M/D)
082120 third field format is in Time format 24hrs

Thanks in advance regards
Mark
Oct 28 '06 #1
3 1632
PEB
1,418 Expert 1GB
Hi,

Use File -> Get Data -> Import or Link

In the dialog window that appears choose txt format

After that be carefull coz there is options to set...

You need to choose fixed width file and there to set your fields... It gives you also a simple. :)

I think you can also attach this kind of files like as database and when you introduce info in this table this is placed in your txt.. But never tried coz I don't believe to txt as datasource :)

:)
Oct 28 '06 #2
Re: Need to link a text file (and reformat).

File / Get Data / Link
Select fixed length text and click between fields to identify field separation.
Click on Advanced and the Import Specification Wizard will appear with the start positions and field lengths of your input (linked table).
Name the fields and change all data types to text. (If you plan to import additional data in this format again, you may save the specification and use it by opening the Specifications and selecting it)
Run a query to append the linked table to an empty table you have created with the fields defined in the correct sequence.

As for using the date and time in calculations and/or displaying these in their proper edited format, your receiving table must be defined with the correct data type (date/time) and one of the associated formats. Refer to Table in Design View / Data Type and Format.
Oct 29 '06 #3
NeoPa
32,556 Expert Mod 16PB
Lots of good stuff
You can also, using the same wizard, import a text file directly into your database, which will create a new table for you.
Pay particular attention to the field type definitions when in 'Advanced' mode.
Oct 29 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Adam Wasi | last post by:
Hi all This is what I have in mind and I will appreciate any suggestions. I am trying to create a xml help system for my application. The schema of the xml file will be <helpsystem> <help...
28
by: Randy Starkey | last post by:
Hi, Does anyone know where I can get a script that show a little plus sign after a line of text, that when you click the plus sign, more text is revealed on that same page, like a continuing...
1
by: Andrew Chanter | last post by:
I am writing a little routine to perform the following operations from an Acces 97 mdb: 1. create a fixed width text file 2. create/establish a table type link to the text file in Access 3....
0
by: RSB | last post by:
Hi Every one, i am trying to create a UserControl and i am passing a Array of strings to it. Now based on the Array elements i am creating the LinkButtons Dynamically. I am also passing a Event to...
2
by: JenHu | last post by:
hi, I have a datagrid in my asp.net application, I am using vb.net language. I want to have my last column as a link column, link to text file. The link path is "c:\Temp\" & F_File_Name, which...
7
by: pushpadant | last post by:
Hi, I have one master page which has some table inside one of the <td> i have my contentplaceholder. on the <head> tag of the master page i have specified link to a global CSS...
20
by: mike | last post by:
I help manage a large web site, one that has over 600 html pages... It's a reference site for ham radio folks and as an example, one page indexes over 1.8 gb of on-line PDF documents. The site...
0
by: preetkanwal0678 | last post by:
Hello all, Am working on PYTHON +BRANWAVE(framework) Actually am Trying 2 make a tree menu using d both. Am not able 2 target the (.tmpl) files and not getting how 2 make frames in...
1
by: vikjohn | last post by:
I have a new perl script sent to me which is a revision of the one I am currently running. The permissions are the same on each, the paths are correct but I am getting the infamous : The specified...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.