Import Format Help

[Lez]

Hi Guys,

Need help being able to create an import spec for data we receive through
from one of our resources. The data is sent as a text file in the following
format:

Field name00 : value
Field name01 : value

So need a method to allow me to import data send in this way? is this
possible

Regards
Lez

 

[Ken Snell \(MVP\)]

You most likely will need to use VBA programming to read the text file line
by line and to write the data into a table via a recordset. You'll need to
post details about the table that is to store the data and provide more
examples of the data records from the text file.

 

[Lez]

Hi Ken,

The text file will be formatted as:

Name : value (text string)
Add1 : value (text string)
Add2 : value (text string)
postcode : value (text string)
tel : value (text string)
mobile : value (text string)
email : value (text string)
source : value (text string)
notes : value (text string)

I have a table, 'tblenquiry' that I will use to import this data into then
use an update query to update the main database table.

tblenquiry has the field names and data types as the text file we receive.

HTH

Regards
Lez

 

[Ken Snell \(MVP\)]

Do the data rows "repeat"? In other words, the first 9 rows are "one data
record", and the next 9 rows are "another data record", etc.?