By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,548 Members | 1,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,548 IT Pros & Developers. It's quick & easy.

ListDatabase to Access

P: 2
I have almost the same issue like in post "Help With Converting List to Database" but with some additional differences.

So I have the following list:

NAME=John Smith
ADDRESS=123 Anystreet
NAME=Dave Jones
ADDRESS=321 Main Street

? Is there a possibility to convert this list into access table (column form) to take into consideration that COLUMNNAME=FIELDRECORD and between list records can be some additional text headers which should not be imported.

Thank you very much.
Oct 18 '06 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,418
Hi Vadim,

It is possible.... With Vb or without VB...

If without VB you need to add a complementary column before or after each row that indicates the number of record... So the first 10 rows will have as number of record = 1 the second 10 = 2 and so on...

Finally you have to import your table as text delimited file with delimiter "="

And you'll have 3 columns....

To obtain your table you need to do a crosstab query.. as column value you choose the column with fields and as value the first seen value from the column with values...

Remember to group by also number of record..

Finnally you'll have a query that shows the number of record, and the values from the respective record...

You need to save this query

Create new one based on the previous crosstab and Choose as query type - Make table query...

Run it!

This is the last step :)

Best regards

Oct 21 '06 #2

P: 2
First of all thank you for your feedback Vladimir.
Well, I'll be very happy to have the third column which indicates the record number but unfortunately I don't have it. And I really don't know how to make it because the external file contains two tables one under another fortunately the column names are not the same between them e.g.

NAME=John Smith
ADDRESS=123 Anystreet

NAME1=John Smith

The steps behind is very clear for me, thank you. I think only VB code can save in such situation.
All suggestions will be grateful.
Oct 23 '06 #3

Post your reply

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