Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Giffy
  • Order by date
  1. Giffy

    MS Access report to html using html template/css

    Can anyone help me with a step-by-step working example of converting an MS Access report to html using a template or css? Should I use the SendObject Method? Access help is a bit skimpy. Can you help?
  2. Giffy

    Importing selected data from a text file into an MS Access table.

    Hi jnicks, Such short code interests me hugely. I am not aware of River text handling. How can I use it with VBA to import the data range "DELIVERY DATA" into an MS Access table? Thanks for taking time and interest. Regards Howard
  3. Giffy

    Importing selected data from a text file into an MS Access table.

    Hi Grant, thanks a million. I reckon I can take this project further now. I still hope that you will be able to help in future. Regards Howard
  4. Giffy

    Extracting Data from a text file - Please Help

    I wonder who is going to answer this? Hi Steve, Did you implement Oharab's class successfully? I am also needing to import text files into MS Access. I run this code and get to a macro dialogue box with csGetAlign in it. I step into this procedure and end at Compile error: Variable not...
  5. Giffy

    Importing selected data from a text file into an MS Access table.

    Hi Grant, I am getting on fine with this and see that it will be soon that I can use it. As you noticed, the table name is in the first field of your header array i.e. INSERT INTO Table4 ([WEEKLY SUMMARY], [SEASON], [WEEK], [FIBRE], [MOISTURE], [TONS]) VALUES ('', '2002', '8', '67.121'...
  6. Giffy

    Importing selected data from a text file into an MS Access table.

    Grant, the code works properly and is most educational. It will help me to understand the next step. Thanks. Can I take your offer up in imorting the DELIVERY DATA data range only into an Access table using VBA? To refresh, the challenge that this text file (as at the beginning of the thread)...
  7. Giffy

    Importing selected data from a text file into an MS Access table.

    Grant, Thanks for you precious time. When I run the above code, Access gives the following error. Compile error: Method or Data member not found Grant, this occurs at the code line List1.AddItem thisLineType .AddItem is highlighted and the help reveals the following suggestions:- Method...
  8. Giffy

    Importing selected data from a text file into an MS Access table.

    Hi Grant, I need to search for the following block of data only and import it into an an MS Access table in this format:- DELIVERY DATA,SEASON,WEEK,DATE,VOUCHER,TONS ,2002,8,18-04-2002 12:22:52,B170485, 27.300 ,2002,8,18-04-2002 17:22:05,B170786, 28.250 ,2002,8,19-04-2002...
  9. Giffy

    Importing selected data from a text file into an MS Access table.

    Thanks Grant, You were right on the button-I do need to put the data into different tables. I will try your code and let you know how I got it it to work. Howard
  10. Giffy

    Importing selected data from a text file into an MS Access table.

    I have a text file with four summary headers and one detail block of data labelled "DELIVERY DATA". These are separated by open lines. This text file is downloaded from the mainframe in exactly the same format every time. Please help me with a working sample of VBA code to automate...

Part and Inventory Search

Back
Top