Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-21-2009, 08:37 AM   #1
Helpy
Registered User
 
Join Date: Jul 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Helpy is on a distinguished road
Create table in access from a text file

Good day, Sorry but my english is not good. :oI do see is first a question, I'm stuck with a failure to conduct this program. I have three files that I am enclosing, Ejem.txt and Ejem2.txt values of 7 months from January to August with their respective headers and other files EjLatLong.txt this data is latitude and longitude. What I do is create an Access database with 2 tables (MesesE1, MesesE2) corresponding to a data Ejem.txt and the other values should Ejem2.txt both fields: ID, Lat, Long, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug. The latitude and longitude data must be removed from the file EjLatLong to fill in these fields.
The files are in your head that are 38 * 16 grid this means choosing the latitude and longitude must look at this file because the latitude and longitude is given by 16 lat and long 38, brother-in-law went to the table to fill these areas must be considered that for the first 38 months of data will be the first value in latitude and longitude will change for each of the 38 data for the following latitude 38 recently changed to its second value and so every 38 . I have to do this, programming in visual access, will have any idea how to do it.
Has been understood and I hope I can help:confused:.
Many thanks for the time:)

Attached Files
File Type: txt Ejem.txt (38.7 KB, 93 views)
File Type: txt Ejem2.txt (38.7 KB, 72 views)
File Type: txt EjLatLong.txt (479 Bytes, 74 views)

Helpy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Retain Sequence in Table from Original Imported Text File shaggy General 4 01-30-2009 04:15 PM
How to display a message while generating report.. vsap Forms 1 06-07-2005 07:25 PM
[SOLVED] XP - Importing a Text file into Access 2000-3 cynthia brown Modules & VBA 1 06-03-2005 12:48 PM
Access to Text File - Export manianz General 4 06-04-2004 06:44 AM




All times are GMT -8. The time now is 02:20 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World