Search results for query: *

LesPaul Just think of it as a big text file, and not in a columnar format, ie some columns will have extra info, so pushes other columns out to right. Hence messy import which makes queries a pain as you cannot specify one field. Richard Not very comfortable with vba, mainly used dbases on...

Thanks Richard that is extremely helpful. No this is a one time migration from an old bookings database. I would under normal conditions normalize but that is a huge task in itself and as with ALL clients time is against me.. I have created two tables now ,BOOKINGS and NO BOOKINGS. However the...

Data structure - Master table with 60 fields, unix import as below. 0000388,Active,MR,M,abc,5 Wave Drive,,Kansas,Kent,DT6 1ZX,UK,01999 123456,SAME,,Aþ0000388,0105297,Firm,12469,10/08/02,OC,12470,12580,12584þ0000388,Broch BH98,0010884,05/11/97,11/03/98,OC,MAIL4,,Encl...

Howdi AceMan Can't help you with the delimiter, it was an export from a unix flat file. Can't seem to get a grip with what you are doing here. Does this function grab the left characters up until "þ" found. Then I suppose I have to instigate an update function to place it in the...

I am looking to build a query on a number of fields in a amster table based on the "mailing codes" stored in another table. I want to pull off a list of customers in a master table (122,000) that do not have any of the codes listed in the mailing codes table. What would be the best...

I have a table that I have to select out of it all the records that have requested a brochure on their own accord (ie thay have not received a mailer). This enatils searcing all fields, to make sure there is no MAIL4, Encl Ms, etc etc. As this is a UNIX import all the fields are all over the...

destination field "email" is in same table.

I have imported a large text file (UNIX) into a table. Some of the fields have shifted etc and i have a lot of sorting to do. One key field has the email address then a limiter then booking number, as below xt@abc.fsnet.co.ukþ0000189 I need to ditch the delimiter "þ" then move the...

could this be a new table? ie created through the append rather than creating initially? thanx

I have a global table that houses a huge text import. I now want to extract some of that data based on a query into another table to do some work on it. What is the best way to do this?

I have a text file as below, with over 120,000 records that my client would like to persuse with various search criteria from within Access. would appreciate views and guides on this. Each record houses address details, one copy, booking details could be numerous and brochure details again...

Thanks, There is no record type, the comma's are just placed there for simplicity, in real life they contain dates, email addresses, booking ref's etc etc. The problem is after the $ that record mey be repeated. Below is one row. 0000388,Active,MR,M,Ball,5 Wave Down,,WHITing,Sussex,so32...

I am starting a project where my client wants a unix flatfile imported into access. The file contains 120,000 unique records. The records are delimited and the following format. 3801111,,,,,,,,$3801111,,,,,,,,,$3801111,,,,,,,,,,. Whereby the first record is clients name and addressetc then...